| id (PK) |
int8(19) |
NOT NULL |
|
|
| name |
varchar(50) |
NOT NULL |
|
|
| bio_brief |
varchar(255) |
|
|
|
| bio_extended |
oid(10) |
|
|
|
| id (PK) |
int8(19) |
NOT NULL |
|
|
| name |
varchar(255) |
|
|
|
| id (PK) |
int8(19) |
NOT NULL |
|
|
| name |
varchar(255) |
|
|
|
| id (PK) |
int8(19) |
NOT NULL |
|
|
| name |
varchar(255) |
|
|
|
| id (PK) |
int8(19) |
NOT NULL |
|
|
| name |
varchar(255) |
|
|
|
| id (PK) |
int8(19) |
NOT NULL |
|
|
| email (UNIQUE) |
varchar(255) |
|
|
|
| name |
varchar(255) |
|
|
|
| uuid (PK) |
uuid(2147483647) |
NOT NULL |
|
|
| name |
varchar(50) |
NOT NULL |
|
|
| birthdate |
date(13) |
|
|
|
| status |
int2(5) |
|
|
|
| version |
int4(10) |
|
|
|
| id (PK) |
int8(19) |
NOT NULL |
|
|
| creationdate |
timestamp(29) |
|
|
|
| email (UNIQUE) |
varchar(50) |
NOT NULL |
|
|
| firstname |
varchar(50) |
NOT NULL |
|
|
| lastname |
varchar(50) |
NOT NULL |
|
|
| photo |
oid(10) |
|
|
|
Primary key: id, id, id, id, id, id, uuid, id
Indexes: - customer_email_key (email) UNIQUE - customer_pkey (id, id, id, id, id, uuid, id, id) UNIQUE
CREATE TABLE customer (
id int8(19) NOT NULL,
name varchar(50) NOT NULL,
bio_brief varchar(255),
bio_extended oid(10),
id int8(19) NOT NULL,
name varchar(255),
id int8(19) NOT NULL,
name varchar(255),
id int8(19) NOT NULL,
name varchar(255),
id int8(19) NOT NULL,
name varchar(255),
id int8(19) NOT NULL,
email varchar(255),
name varchar(255),
uuid uuid(2147483647) NOT NULL,
name varchar(50) NOT NULL,
birthdate date(13),
status int2(5),
version int4(10),
id int8(19) NOT NULL,
creationdate timestamp(29),
email varchar(50) NOT NULL,
firstname varchar(50) NOT NULL,
lastname varchar(50) NOT NULL,
photo oid(10),
PRIMARY KEY (id, id, id, id, id, id, uuid, id)
);