dfdd

Tables (11)

Categories

  • category_number — BIGINT
  • store_number — BIGINT — NOT NULL
  • category — VARCHAR(255) — NOT NULL

GUEST

  • GUEST_NUMBER — BIGINT — NOT NULL
  • ORDER_NUMBER — BIGINT — NOT NULL
  • REVIEW_NUMBER — BIGINT — NOT NULL
  • GUEST_NICKNAME — VARCHAR(255)
  • GUSET_IMG — VARCHAR(255)

Menus

  • menu_number — BIGINT
  • STORE_NUMBER — BIGINT — NOT NULL
  • category_number — BIGINT — NOT NULL
  • menu_name — VARCHAR(255) — NOT NULL
  • menu_img — VARCHAR(255)
  • menu_description — TEXT
  • menu_price — INT — NOT NULL
  • menu_state — TINYINT — NOT NULL

Orders

  • order_number — BIGINT
  • store_number — BIGINT — NOT NULL
  • order_address — VARCHAR(255) — NOT NULL
  • order_total_price — INT — NOT NULL
  • order_date — DATETIME — NOT NULL
  • order_state — INT — NOT NULL
  • order_count — INT — NOT NULL

REVIEW_COMMENT

  • REVIEW_NUMBER — BIGINT — NOT NULL
  • COMMENT — VARCHAR(255)
  • REVIEW_COMMENT_DATE — DATE — NOT NULL

REVIEW_EVENT_NOTICE

  • STORE_NUMBER — BIGINT
  • REVIEW_NOTICE_PHOTO — VARCHAR(255)
  • REVIEW_NOTICE_TEXT — TEXT

USER

  • user_number — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • user_pw — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • user_email — VARCHAR(255) — NOT NULL
  • user_birth — VARCHAR(255) — NOT NULL
  • user_phonenumber — VARCHAR(255) — NOT NULL
  • user_business_number — INT — NOT NULL
  • user_privacy_policy — BOOLEAN — NOT NULL
  • user_marketing — BOOLEAN

order_detail

  • order_detail_number — BIGINT
  • menu_number — BIGINT — NOT NULL
  • order_number — BIGINT — NOT NULL
  • order_product_name — VARCHAR(255) — NOT NULL
  • order_quantity — INT — NOT NULL

reviews

  • review_number — BIGINT
  • order_number — BIGINT — NOT NULL
  • GUEST_NUMBER — BIGINT — Foreign key → GUEST.GUEST_NUMBER — NOT NULL
  • review_rating — INT
  • review_date — DATE — NOT NULL
  • review_comments — TEXT
  • review_report — BOOLEAN — NOT NULL

reviews_photos

  • review_number — BIGINT
  • review_photo — VARCHAR(255)

store

  • store_number — BIGINT
  • user_number — BIGINT — NOT NULL — AUTO_INCREMENT
  • store_name — VARCHAR(255) — NOT NULL
  • store_logo — VARCHAR(255) — NOT NULL — url 받아옴
  • store_category — ENUM('치킨', '중식', '돈까스/회', '피자', '패스트푸드', '찜/탕', '족발/보쌈', '분식', '카페/디저트', '한식', '고기', '양식', '아시안', '야식', '도시락')
  • store_open_time — TIME — NOT NULL
  • store_close_time — TIME — NOT NULL
  • store_break_start — TIME
  • store_break_end — TIME
  • store_address — VARCHAR(255)
  • store_description — TEXT