Anonymous user
Table creation: Difference between revisions
→[[PostgreSQL]]
No edit summary |
|||
Line 13:
active bool not null default 't',
username varchar(16) unique not null,
balance float default 0,
age int2,
notes text
Line 23 ⟶ 24:
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
| |||