|
Postgres developers, please feel free to add additional data-types you commonly use to this example.
<lang sql>-- This is a comment
CREATE SEQUENCE account_seq start 100;
CREATE TABLE account (
account_id int4 PRIMARY KEY DEFAULT nextval('account_seq'),
created date not null default now(),
active bool not null default 't',
username varchar(16) unique not null,
balance float default 0,
age int2,
notes text
);
CREATE TABLE account_note (
account_id int4 not null REFERENCES account,
created timestamp not null default now(),
note text not null,
unique(account_id, note)
);
-- bool: 't', 'f' or NULL
-- int2: -32768 to +32767
-- int4: -2147483648 to +2147483647
-- float: decimal
-- date: obvious
-- timestamp: date time
-- char(#): space padded text field with length of #
-- varchar(#): variable length text field up to #
-- text: not limited</lang>
| 