[COSE371] Term proj
Tables (8)
account
- id — varchar(15) — Primary key — NOT NULL
- credit — int — NOT NULL
- rating — varchar(10) — NOT NULL
- role — varchar(10) — NOT NULL
account_coupon_map
- account_id — varchar(15) — Primary key — NOT NULL
- coupon_id — int — Primary key — NOT NULL
coupons
- id — int — Primary key — NOT NULL
- code — varchar(2) — NOT NULL
- discount_factor — float — NOT NULL
enrollment
- tutee — varchar(15) — NOT NULL
- tutor — varchar(15) — NOT NULL
- code — varchar(2) — NOT NULL
- lecture_name — varchar(20) — NOT NULL
- lecture_price — int
lecture
- code — varchar(2) — Primary key — NOT NULL
- name — varchar(20) — Primary key — NOT NULL
- price — int — Primary key — NOT NULL
- tutor — varchar(15) — Primary key — NOT NULL
rating_info
- rating — varchar(10) — Primary key — NOT NULL
- condition — int — NOT NULL
- discount — numeric(4,2) — NOT NULL
subject
- code — varchar(2) — Primary key — NOT NULL
- subject_name — varchar(20) — NOT NULL
users
- id — varchar(15) — Primary key — NOT NULL
- password — varchar(20) — NOT NULL