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