System Information

generated by AceQL v11.0
generated on 2022-06-10 20:47:26

 

 

Tables

public.aceql_banned_user [table]
username varchar(254) not null
ip_address varchar(254) not null
sql_database varchar(254) not null
sql_firewall_manager varchar(254) not null
sql_statement varchar(4000)
is_metadata int4
dt_creation timestamp not null

 

public.aceql_denied_request [table]
date_event timestamp not null
username varchar(254) not null
ip_address varchar(254) not null
sql_database varchar(254) not null
sql_firewall_manager varchar(254) not null
sql_statement varchar(4000) not null
is_metadata int4
is_prepared_statement int4
parameter_values varchar(4000) not null

 

public.aceql_user [table]
username varchar(254) not null
encrypted_password varchar(4000) not null
Primary Key
aceql_user_pkey [primary key]
username ascending

 

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

 

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
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.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.users [table]
username varchar(300) not null
encrypted_password varchar(300) not null
Primary Key
users_pkey [primary key]
username ascending