[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