toyProject
Tables (4)
Branches (가맹점)
- Field (branch_id) — varchar — Primary key
- Field3 (branch_name) — varchar
- Field (branch_address) — varchar
- Field (branch_owner_id) — varchar
Customers (고객)
- Field (customer_id) — varchar — Primary key
- Field3 (customer_name) — varchar
Review_Replies (리뷰 답변)
- Field (reply_id) — varchar — Primary key
- Key1 (reply_title) — varchar
- Key2 (reply_time) — timestamptz
- Field (reply_modify_time) — timestamptz
- Key (reply_content) — varchar — NOT NULL
- Field (fk_review_id) — varchar — Foreign key → Reviews.Field
Reviews (리뷰)
- Field (review_id) — varchar — Primary key
- Key1 (review_title) — varchar
- Key2 (review_make_time) — timestamptz
- Field1 (review_modify_time) — timestamptz
- Field2 (review_content) — varchar
- Field (review_point) — INT
- Field (review_photo_url) — varchar
- Field (review_hide) — boolean
- Field (fk_customer_id) — varchar — Foreign key → Customers.Field
- Field (fk_review_branch_id) — varchar — Foreign key → Branches.Field