One Stone Soup

Warm community, open collaboration, sustainable living

DB

CREATE SEQUENCE member_id_seq START 1234; #DROP TABLE member IF EXISTS; CREATE TABLE member( id smallint DEFAULT nextval('member_id_seq'::regclass), first_name text, last_name text, alias text, email text, password text, created_date numeric, registered_date numeric, verified_date numeric, last_password_reset numeric ); CREATE SEQUENCE service_id_seq START 1; #DROP TABLE member_service IF EXISTS; CREATE TABLE member_service( member_id smallint, service_id smallint DEFAULT nextval('service_id_seq'::regclass), service_alias text, used_count numeric, available_count numeric, start_date numeric, end_date numeric, access_token text, last_used_date numeric ); #DROP TABLE member_service_description IF EXISTS; CREATE TABLE member_service_description( service_id smallint, service_name text, service_home_page text ); #DROP TABLE member_group IF EXISTS; CREATE TABLE member_group( group_id numeric, name text, owner_id numeric ); #DROP TABLE group_membership IF EXISTS; CREATE TABLE group_membership( group_id numeric, member_id numeric ); #DROP TABLE account IF EXISTS; CREATE TABLE account( account_id numeric, owner_id numeric, name text, balance numeric ); #DROP TABLE account_ledger IF EXISTS; CREATE TABLE account_ledger( account_ledger_id numeric, account_id numeric, owner_id numeric, amount numeric, description text, source text, entry_date numeric, entry_type text ); select * from member; select * from member_service; select * from member_service_description; select * from member_group; select * from account; select * from account_ledger;