System Information

generated by AceQL v6.2
generated on 2020-11-18 15:19:25

 

 

Tables

public.banned_usernames [table]
username varchar(255) not null
Primary Key
banned_usernames_pkey [primary key]
username ascending

 

public.customer [table]
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

 

public.customer_auto [table]
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

 

public.documentation [table]
item_id int4 not null
item_doc text not null
Primary Key
documentation_pkey [primary key]
item_id ascending

 

public.orderlog [table]
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

 

public.orderlog2 [table]
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

 

public.product_image [table]
product_id int4 not null
name varchar(64) not null
image oid
Primary Key
product_image_pkey [primary key]
product_id ascending

 

public.regions [table]
region_name varchar(32) not null
zips _varchar not null
Primary Key
regions_pkey [primary key]
region_name ascending

 

public.regions_integer [table]
region_name varchar(32) not null
zips _int4 not null
Primary Key
regions_integer_pkey [primary key]
region_name ascending

 

public.user_login [table]
username varchar(255) not null
hash_password varchar(40) not null
Primary Key
user_login_pkey [primary key]
username ascending

 

public.view1 [view]
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)