We DID

Tables (4)

Busi_FeedBack (Business Feedback)

  • Key (Busi_Reg_Num) — INT — Foreign key → Business.Key — NOT NULL
  • Field (Opinion) — VARCHAR
  • Field (Review) — VARCHAR
  • Field (Request) — VARCHAR

Business (Business Information)

  • Key (Busi_Reg_Num) — INT — Primary key — NOT NULL
  • Field (Busi_Name) — VARCHAR
  • Field (Busi_Info) — VARCHAR

Sell_Req (Seller Request for Service)

  • Key (Req_ID) — INT — Primary key — NOT NULL
  • Key (Sel_Name) — VARCHAR — Foreign key → Seller.Key
  • Key (Busi_Name) — VARCHAR — Foreign key → Seller.Key
  • Key (Busi_Reg_Num) — INT — Foreign key → Seller.Key — NOT NULL
  • Field (Req_Type) — INT
  • Field (Req_EMAIL) — VARCHAR
  • Field (Req_Info) — VARCHAR

Seller (Seller Information)

  • Key (Sel_Name) — VARCHAR — Primary key
  • Key (Busi_Name) — VARCHAR — Primary key
  • Key (Busi_Reg_Num) — INT — Foreign key → Business.Key — NOT NULL
  • Field (Busi_More) — VARCHAR