Database

NOW suspended - provided here for information only

The membership database structure as designed in 1996 is as below. We have reproduced it here so that freestanding cells or communities have a guide to the sort of data they may need to establish.

If you maintain a database of citizens within your cell or community, then you must make sure that the information is kept securely and secretly.

The HQ files are no longer maintained in the presidents control for security reasons.

This database will not at any time be reintroduced centrally

Database Structure

Name And Address (Database)

Note may need a counter 8 bytes in all tables to give uneque key ??

all date fields are date/time fields

Na membership number stored as number.family member, with 00 at end. Check digit calculated each time.

Name And Address(Table)

Field	Note	Type	VB	Variable Name	Keys
Record Status	(Current /Old)	memo(v)	$
Computer Flag		memo(v)
Direct Mail Flag		memo(v)
Marketing Flag		memo(v)
Surname Name		memo(v)
First Name		memo(v)
Title Conventional	(Ie Mr Or Mrs Ms lord Etc.)	memo(v)
Sex	(M Or F)	memo(v)
D Of B	(Ddmmyyyy)	memo(v)
New Atlantis Membership Number		Currency
Ref. No	I.e. Sequence No	Currency
Company		memo(v)
House Name		memo(v)
Address Line 1		memo(v)
Address Line 2		memo(v)
Address Line 3		memo(v)
Address Line 4		memo(v)
Postcode / Zip		memo(v)
Mailsort Code		memo(v)
Country		memo(v)
Telephone Home		memo(v)
Telephone Daytime		memo(v)
Fax		memo(v)
E Mail		memo(v)
Maiden Name	(If Female)	memo(v)
Mothers Maiden Name		memo(v)
Password		memo(v)
note		memo(v)
Source		memo(v)

Trusts -Master(Table)

Field	Note	Type	Variable Name
New Atlantis Membership Number.		Currency
Trust Name		memo(v)
Status	(Ghost Private Company.......)	memo(v)
Director Mem No	(I.e. Where Mail Goes)	Currency

Trusts -Members(Table)

Field	Note	Type	Variable Name
Trusts New Atlantis Membership Number		Currency
Members Na Membership Number		Currency
Date Joined		Date
Date Left		Date

Correspondence(Table)

Field	Note	Type	Variable Name
NA Membership Number Or Ref. No		Currency
Date		Date
Club /Heading		memo(v)
Topic		memo(v)
File Name		memo(v)

Notes(Table)

Field	Note	Type	Variable Name
NA Membership Number Or Ref. No		Currency
Date		Date
Note		memo(v)
Action List Of		memo(v)
Completed		memo(v)

A/C Transaction List(Table)

Field	Note	Type	Variable Name
Date		Date
New Atlantis Membership Number Or Ref. No		Currency
Currency		memo(v)
Value		Currency
Vat		Currency
Cash Received By		memo(v)
For The Benefit Of		memo(v)
Type	I.e. Cheque, Transfer Etc.	memo(v)
Cheque Listing For Account		memo(v)

Order Database

Transactions(Table)

Field	Note	Type	Variable Name
Transaction Type	(O Or C = Credit)	memo(v)
Date		Date
New Atlantis Membership Number Or Ref. No		Currency
Ordered From	(i.e. Club)	memo(v)
Product Code		memo(v)
Qty		long
Cc Number		memo(v)
Despatched Date		Date
Despatch Method		memo(v)
Value -Goods		Currency
Value Carriage		Currency
Vat		Currency
Currency		memo(v)
Note		memo(v)

Products(Table)

Field	Note	Type	Variable Name
Product Code		memo(v)
Version		memo(v)
Description (Short)		memo(v)
Description - (Long)		memo(v)
Available Now	Y or N	memo(v)
ISBN		memo(v)
Price		Currency
Normal Despatch Method		memo(v)
Postage / Carriage		Currency
Stock Level		Long
Reorder Point		Long
Reorder From		memo(v)

? discounts

Old Material (Database)

Membership Descriptions(Table)

Field	Note	Type	Variable Name
Old Mem Code		memo(v)
Description		memo(v)

Old Membership Transactions(Table)

Field	Note	Type	Variable Name
Ref. No	(Link To Name And Address)	Currency
Date		Date
Old Mem Code		memo(v)