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)
Month To		memo(v)
Note		memo(v)

(Product Descriptions - From Stock File)

Old Order Transactions(Table)

Field	Note	Type	Variable Name
Ref. No	(Link To Name And Address)	Currency
Product Code		memo(v)
Date		Date
Qty		Int
Note		memo(v)

New Atlantis (Database)

Membership Details(Table)

Membership Number

Promotion Transaction / History(Table)

Field	Note	Type	Variable Name
Membership Number		Currency
Date Appointed		Date
Grade	(I.e. Count)	memo(v)
Task	I.e. B&B Organise	memo(v)
Documentation Complete date		memo(v)
Date Resigned		Date
Note		memo(v)

Postcode Areas Allocated(Table)

Field	Note	Type	Variable Name
Postcode		memo(v)
Size	(L T C)	memo(v)
New Atlantis Membership Number Of Organiser		Currency
Current Target Favours Per Month		Currency
Current Target New Members Per Month		Currency
Appointment Date For Area		Currency
Resignation Date For Area		Currency
Year Cumulative Target Favours		Currency
Year Cumulative Target Members		Currency
Year Cumulative Actual Favours		Currency
Year Cumulative Actual Members		Currency

Commission History(Table)

Field	Note	Type	Variable Name
Na Membership No		Currency
Postcode Area		memo(v)
Statement Date		Date
Payment Date		Date
Amount		Currency
Line From Statement *		memo(v)

*note maybe split statement line into fields

B&B Club (Database)

Discount Rates(Table)

? (Table)

Basic Data - Member(Table)

Field	Note	Type	Variable Name
Membership Number		Currency
Date Joined		Date
Recruited By	(Organiser Mem No)	Currency
Introduced By	(Member No)	Currency
Date Detail Form Received / Membership Card Produced		memo(v)
Monthly Subscription		Currency
Subscription Incl. Favours	(Qty)	Currency
Day Of Month For Standing Order		int
Bank Name		memo(v)
Bank Address		memo(v)
Transfer Forms Remaining		int
Transfer Forms Reprint Level		int
Balance (Favours) At Last Statement		Currency
Balance Invoices Outstanding (At Last Statement)		Currency

Transactions (Since Last Statement)(Table)

Field	Note	Type	Variable Name
Membership Number		Currency
Transaction Processing Date		Date
Type	S/o Subs, Trans	memo(v)
Currency	(Favours Or Local Currency)	memo(v)
+ Or -		memo(v)
Amount		Currency
Transaction In Batch		memo(v)
Processed by	(pos logon var)	memo(v)
Other Account Number Involved		Currency
note		memo(v)

Transactions History(Table)

(As Above)

Standing Orders(Table)

Field	Note	Type	Variable Name
Membership Number		Currency
Next Transaction Processing Date		Date
Currency	(Favours Or Local Currency)	memo(v)
Amount		Currency
Other Account Number Involved		Currency
Date Set Up		Date
Frequency		memo(v)
Quantity		int
Last Payment Date		Date
Date Cancelled		Date
Quote		memo(v)
Instruction methode	Ie Phone, tran	memo(v)
processed by		memo(v)
Note		memo(v)

Allocations (Authorisations)(Table)

Field	Note	Type	Variable Name
Membership Number		Currency
Allocation Date		Date
Reference	Authorisation code incl operator	memo(v)
Amount		Currency
Account To Credit		Currency
Note		memo(v)

Directory Entries(Table)

Field	Note	Type	Variable Name
Membership Number		Currency
Date Of Entry		Date
Date Last Confirmed		Date
Topic Entry		memo(v)
Sub Topic		memo(v)
Expertise Level		memo(v)
Geographic Coverage		memo(v)
Favours Accepted	Y or N	memo(v)
Note		memo(v)

Poetry Club (Database)

Membership(Table)

Field	Note	Type	Variable Name
Na Membership No Or Ref. No		Currency
Date Joined		Date
Date Membership Pack / Membership Card Produced		Date
Subscription		Currency
Next Membership Renewal Date		Date
Method Of Payment	(Favours- Standing Order Cash)	memo(v)
Date For Standing Order		Date
Bank Name		memo(v)
Bank Address		memo(v)

bank ac no

Membership Transactions(Table)

Field	Note	Type	Variable Name
NA Membership No Or Ref. No.		Currency
Date		Date
Source		memo(v)
Currency		memo(v)
Amount		Currency
Note		memo(v)

Competitions Descriptions(Table)

Field	Note	Type	Variable Name
Comp Code		memo(v)
Comp Description Short		memo(v)
Comp Description Long		memo(v)
Comp Handout -File Name		memo(v)
Next Closing Date		Date
Annual	Y or N	memo(v)
Open To	(Members / Public)	memo(v)
Entry Fee		Currency
Line Limit		memo(v)

Competition Entries (Transactions)(Table)

Field	Note	Type	Variable Name
Membership Number Or Ref. No		Currency
Comp Code		memo(v)
Entry Date		Date
Entry Title		memo(v)
fee paid		Currency
charity suported		memo(v)
Award		memo(v)
Eventual Placing		memo(v)

Pos Charity table with address etc.

Events Descriptions(Table)

Field	Note	Type	Variable Name
Event Code		memo(v)
Event Description Short		memo(v)
Event Handout - File Name		memo(v)
Date Of Event		Date
Closing Date For Bookings		Date
Total Spaces		int
Spaces Left		int
Frequency		memo(v)
Open To	(Members / Public)	memo(v)
Entry Fee Members		Currency
Entry Fee Public		Currency
Note		memo(v)

Event Transactions(Table)

Field	Note	Type	Variable Name
Membership Code Or Ref. No		Currency
Event Code		memo(v)
Booking Made Date		Date
No of places booked		int
Fee Paid		Currency
Balance To Pay		Currency
Balance To Pay By Date		Date
Details Sent		date
Special Arrangements		memo(v)
Note		memo(v)
Attendance		memo(v)

Anthology Descriptions(Table)

Field	Note	Type	Variable Name
Anthology Code		memo(v)
Short Description		memo(v)
Long Description		memo(v)
Handout - File Name		memo(v)
Price When Published		Currency
Price To Members When Published		Currency
Price To Those In Anthology		Currency
Pre Publication Price		Currency
P&P		Currency
Date Published		Date
ISBN		memo(v)

Anthology Transactions(Table)

Field	Note	Type	Variable Name
Member Number Or Ref. No		Currency
Date Or Entry		Date
Source	ie comp entry	memo(v)
Title		memo(v)
Selected By Club	poe no file or N	memo(v)
For Anthology Code		memo(v)
Qualification	(Qty Of Books)	Int
Confirmed By Member	date	Date
Proof's Despatched	date	Date
Corrected	date	Date
Electronic Publishing OK	Y or N	memo(v)
Note		memo(v)

Special ?(Table)

Charters etc