103 lines
2.6 KiB
YAML
103 lines
2.6 KiB
YAML
members:
|
|
'uid': {type: 'CHAR(24) PRIMARY KEY', source: 'Account ID'}
|
|
'Year of Birth':
|
|
'Account Name':
|
|
'First Name':
|
|
'Last Name':
|
|
'Phone':
|
|
'Email':
|
|
|
|
'Address (Street)':
|
|
'Address (City)':
|
|
'Address (State/Province)':
|
|
'Address (Postal Code)':
|
|
'Address (Country)':
|
|
'Profile description':
|
|
'Website':
|
|
'Fax':
|
|
'Contact Person':
|
|
'Password':
|
|
'Position/relation':
|
|
|
|
'Parent Account ID':
|
|
|
|
'Gift Membership purchased by':
|
|
'Purchased Gift Membership for':
|
|
|
|
'Closet Storage #':
|
|
'Storage Shelf #':
|
|
'Personal Studio Space #':
|
|
|
|
'Access Permitted Shops During Extended Hours?': {type: 'BOOLEAN'}
|
|
'Access Front Door and Studio Space During Extended Hours?': {type: 'BOOLEAN'}
|
|
'Access Wood Shop?': {type: 'BOOLEAN'}
|
|
'Access Metal Shop?': {type: 'BOOLEAN'}
|
|
'Access Storage Closet?': {type: 'BOOLEAN'}
|
|
'Access Studio Space?': {type: 'BOOLEAN'}
|
|
'Access Front Door?': {type: 'BOOLEAN'}
|
|
'Access Card Number':
|
|
'Access Card Facility Code':
|
|
|
|
'Auto Billing ID':
|
|
'Billing Method':
|
|
'Renewal Date':
|
|
'Join Date':
|
|
|
|
'Admin note':
|
|
|
|
'Profile gallery image URL':
|
|
'Business card image URL':
|
|
'Instagram':
|
|
'Pinterest':
|
|
'Youtube':
|
|
'Yelp':
|
|
'Google+':
|
|
'BBB':
|
|
'Twitter':
|
|
'Facebook':
|
|
'LinkedIn':
|
|
|
|
'Do not show street address in profile':
|
|
'Do not list in directory':
|
|
|
|
'HowDidYouHear': 'Please tell us how you heard about the Claremont MakerSpace and what tools or shops you are most excited to start using:'
|
|
'authorizeCharge': 'Yes - I authorize TwinState MakerSpaces, Inc. to charge my credit card for the membership and other options that I have selected.'
|
|
'policyAgreement': 'I have read the Claremont MakerSpace Membership Agreement & Policies, and agree to all terms stated therein.'
|
|
'Waiver form signed and on file date.':
|
|
'Membership Agreement signed and on file date.':
|
|
'Agreement Version':
|
|
'Paperwork status':
|
|
'Membership agreement dated': {type: BOOLEAN}
|
|
'Membership Agreement Acknowledgement Page Filled Out': {type: BOOLEAN}
|
|
'Membership Agreement Signed': {type: BOOLEAN}
|
|
'Liability Form Filled Out': {type: BOOLEAN}
|
|
'Audit Date':
|
|
|
|
'IP Address':
|
|
|
|
transactions:
|
|
'sid': {type: CHAR(27)}
|
|
'uid': {type: CHAR(24)}
|
|
'timestamp': {type: 'INT(11)', source: '_dp'} # TODO: should be a real timestamp?
|
|
'type': {source: 'Transaction Type'}
|
|
'sum': {type: 'DECIMAL(13,4)'}
|
|
'fee': {type: 'DECIMAL(13,4)'}
|
|
'event_id': {source: 'eid'}
|
|
'For':
|
|
'Items':
|
|
'Discount Code':
|
|
'Note':
|
|
|
|
# this is painful, but necessary because some users have no uid
|
|
# TODO: fix this horribleness
|
|
'Name':
|
|
'Contact Person':
|
|
'Full Address':
|
|
'Street':
|
|
'City':
|
|
'State/Province':
|
|
'Postal Code':
|
|
'Country':
|
|
'Phone':
|
|
'Email':
|