원티드 be 온보딩
테이블 (4)
consumer_tb (Untitled3)
- PK (member_id) — big int — 외래 키 → member_tb.PK — NOT NULL
- Field (role) — varchar(20)
- Field (product_list)
member_tb (Untitled)
- PK (member_id) — big int — 기본 키 — NOT NULL
- Field2 (grade) — varchar(20)
- Field3 (name) — varchar(20)
- Field4 (nick_name) — varchar(20)
- Field5 (email) — varchar(50)
- Field6 (address) — varchar(100)
- Field7 (number) — varchar(20)
- Field8 (id) — varchar(20)
- Field9 (pw) — varchar(50)
product_tb (Untitled2)
- PK (product_id) — big int — 기본 키 — NOT NULL
- FK (member_id) — big int — 외래 키 → seller_tb.PK — NOT NULL
- Field (name) — varchar(20)
- Field2 (price) — int
- Field3 (status) — varchar(20)
- Field4 (quantity) — int
seller_tb (Untitled4)
- PK (member_id) — big int — 외래 키 → member_tb.PK — NOT NULL
- Field (role) — varchar(20)
- Field (product_list)