Table creation/Postal addresses: Difference between revisions

Content added Content deleted
No edit summary
Line 1,199: Line 1,199:
<lang sql>
<lang sql>
CREATE TABLE Address (
CREATE TABLE Address (
addrID Integer generated by default as identity,
addrID Integer generated by default as identity,
addrStreet Varchar(50) not null,
addrStreet Varchar(50) not null,
addrCity Varchar(25) not null,
addrCity Varchar(25) not null,
addrState Char(2) not null,
addrState Char(2) not null,
addrZIP Char(10) not null
addrZIP Char(10) not null
)</lang>
)</lang>