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