create table hudsonu.customer(
customer_id Integer
, first_name char(15)
, last_name varchar(25)
, address varchar(30)
, city varchar(25)
, state char(5)
, zip char(9)
, email varchar(40)
, phone char(15)
);
grant select on hudsonu.customer to public;
create table hudsonu.sale(
sale_id Integer
, sale_time date
, customer_id Integer
, shipping Decimal (4,2)
, tax Decimal (4,2)
);
grant select on hudsonu.sale to public;
create table hudsonu.sale_product(
product_id Integer
, sale_id Integer
, product_size char(20)
, price Decimal (5,2)
, qty Integer
);
grant select on hudsonu.sale_product to public;
create table hudsonu.product(
product_id Integer
, name varchar(100)
, in_store char(1)
, embellishment_type varchar(30)
, fabric varchar(35)
, fit char(20)
, graphic_type varchar(35)
, origin char(15)
, season_code varchar(30)
, vendor_id Integer
, color_code varchar(25)
, single_sku_catalog_entry Integer
, catalog varchar(25)
, category char(20)
, subcategory varchar(25)
, current_price decimal (5,2)
);
grant select on hudsonu.product to public;
create table hudsonu.region(
state_code char(2)
, state_name char(20)
, region char(10)
, division char(20)
);
grant select on hudsonu.region to public;
create table hudsonu.product_size(
product_id Integer
, product_size char(20)
);
grant select on hudsonu.product_size to public;
create table hudsonu.vendor(
vendor_id Integer
, name varchar(35)
, url varchar(40)
, address varchar(35)
, address2 char(15)
, city char(20)
, state char(5)
, zip char(5)
, phone char(15)
, fax char(15)
);
grant select on hudsonu.vendor to public;
create table hudsonu.approval(
approval_code char(4)
, description varchar(60)
);
grant select on hudsonu.approval to public;
create table hudsonu.building(
building_code char(4)
, name char(25)
, address char(20)
);
grant select on hudsonu.building to public;
create table hudsonu.corequisite(
course_code char(11)
, coreq_code char(11)
);
grant select on hudsonu.corequisite to public;
create table hudsonu.course(
course_code char(11)
, title varchar(100)
, description varchar(3000)
, dept_code char(4)
, credits int
, pre_reqs varchar(250)
, core_area varchar(25)
, inquiry_area varchar(30)
, recommendation varchar(310)
);
grant select on hudsonu.course to public;
create table hudsonu.course_emphasis(
emphasis_code char(4)
, course_code char(10)
);
grant select on hudsonu.course_emphasis to public;
create table hudsonu.crosslist(
course_code char(11)
, course_group int
);
grant select on hudsonu.crosslist to public;
create table hudsonu.delivery(
delivery_code char(4)
, name varchar(32)
, description varchar(200)
);
grant select on hudsonu.delivery to public;
create table hudsonu.department(
dept_code char(4)
, division char(32)
, name char(36)
, office_number char(5)
, building_code char(4)
, chair_code char(20)
, blurb varchar(250)
);
grant select on hudsonu.department to public;
create table hudsonu.emphasis(
emphasis_code char(4)
, name varchar(40)
, has_major decimal(1,0)
, has_minor decimal(1,0)
, interdisciplinary decimal(1,0)
, dept_code char(4)
, description varchar(350)
, director_code char(20)
);
grant select on hudsonu.emphasis to public;
create table hudsonu.instruction(
instructor_code char(20)
, section_id int
);
grant select on hudsonu.instruction to public;
create table hudsonu.instructor(
instructor_code char(20)
, first_name char(20)
, last_name char(25)
, dept_code char(4)
, phone char(14)
, email char(30)
, office_number char(5)
, building_code char(4)
, status char(9)
, terminal_degree char(3)
, institution varchar(40)
);
grant select on hudsonu.instructor to public;
create table hudsonu.meeting(
section_id int
, days char(5)
, start_time char(8)
, duration int
, room char(10)
, building_code char(4)
);
grant select on hudsonu.meeting to public;
create table hudsonu.restriction(
emphasis_code char(4)
, course_code char(8)
, standing_allowed char(6)
);
grant select on hudsonu.restriction to public;
create table hudsonu.section(
section_id int
, course_code char(10)
, term_code int
, crn int
, sec_num int
, status char(15)
, delivery_code char(4)
, cap int
, approval_code char(4)
, note varchar(270)
);
grant select on hudsonu.section to public;
create table hudsonu.student_cap(
section_id int
, category varchar(50)
, cap int
, enrolled int
);
grant select on hudsonu.student_cap to public;
create table hudsonu.term(
term_code int
, year int
, semester char(6)
, begin Date
, end Date
);
grant select on hudsonu.term to public;