generated by | AceQL v4.0 |
generated on | 2020-01-19 18:37:53 |
username | varchar(255) not null | |
Primary Key | ||
banned_usernames_pkey | [primary key] | |
username | ascending |
customer_id | int4 not null | |
customer_title | bpchar(4) | |
fname | varchar(32) | |
lname | varchar(32) not null | |
addressline | varchar(64) not null | |
town | varchar(32) not null | |
zipcode | bpchar(10) not null | |
phone | varchar(32) | |
Primary Key | ||
customer_pkey | [primary key] | |
customer_id | ascending | |
Foreign Keys | ||
orderlog2_customer_id_fkey | [foreign key, with no action] | |
customer_id ?(0..many) public.orderlog2.customer_id |
customer_id | serial not null | |
auto-incremented | ||
customer_title | bpchar(4) | |
fname | varchar(32) | |
lname | varchar(32) not null | |
addressline | varchar(64) | |
town | varchar(32) | |
zipcode | bpchar(10) not null | |
phone | varchar(32) | |
Primary Key | ||
customer_auto_pkey | [primary key] | |
customer_id | ascending |
item_id | int4 not null | |
item_doc | text not null | |
Primary Key | ||
documentation_pkey | [primary key] | |
item_id | ascending |
customer_id | int4 not null | |
item_id | int4 not null | |
description | varchar(64) not null | |
item_cost | numeric(131089, 0) | |
date_placed | date not null | |
date_shipped | timestamp | |
jpeg_image | oid | |
is_delivered | int4 | |
quantity | int4 not null | |
Primary Key | ||
orderlog_pkey | [primary key] | |
customer_id | ascending | |
item_id | ascending |
customer_id | int4 not null | |
item_id | int4 not null | |
description | varchar(64) not null | |
item_cost | numeric(131089, 0) | |
date_placed | date not null | |
date_shipped | timestamp | |
jpeg_image | oid | |
is_delivered | int4 | |
quantity | int4 not null | |
Primary Key | ||
orderlog2_pkey | [primary key] | |
customer_id | ascending | |
item_id | ascending | |
Foreign Keys | ||
orderlog2_customer_id_fkey | [foreign key, with no action] | |
customer_id (0..many)? public.customer.customer_id |
product_id | int4 not null | |
name | varchar(64) not null | |
image | oid | |
Primary Key | ||
product_image_pkey | [primary key] | |
product_id | ascending |
username | varchar(255) not null | |
hash_password | varchar(40) not null | |
Primary Key | ||
user_login_pkey | [primary key] | |
username | ascending |
customer_id | int4 | |
customer_title | bpchar(4) | |
fname | varchar(32) | |
lname | varchar(32) | |
addressline | varchar(64) | |
town | varchar(32) | |
zipcode | bpchar(10) | |
phone | varchar(32) |