mini_eat

Tables (13)

Members

  • member_seq — BIGINT — NOT NULL
  • member_id — VARCHAR(30) — NOT NULL
  • member_pwd — VARCHAR(255) — NOT NULL
  • member_name — VARCHAR(30) — NOT NULL
  • member_email — VARCHAR(30) — NOT NULL
  • member_phone — VARCHAR(30) — NOT NULL
  • member_type — ENUM — NOT NULL
  • reg_date — DATETIME — NOT NULL

Review

  • res_seq — BIGINT — Primary key — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • rating — DOUBLE
  • content — TEXT
  • reviewPicUrl — VARCHAR(255)
  • createdAt — DATETIME
  • modifiedAt — DATETIME
  • status — ENUM('PUBLIC','PRIVATE')

admin

  • admin_seq — INTEGER — NOT NULL
  • admin_name — VARCHAR(30) — NOT NULL
  • admin_id — VARCHAR(30) — NOT NULL
  • admin_pw — VARCHAR(255) — NOT NULL

category

  • category_id — BIGINT — NOT NULL
  • restaurant_type — VARCHAR(50)

menu

  • menu_id — INTEGER — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • menu_name — VARCHAR(50)
  • menu_info — TEXT
  • menu_image — VARCHAR(255)
  • menu_price — VARCHAR(50)
  • menu_type — ENUM

owner_reviews

  • res_seq — BIGINT — NOT NULL
  • content — TEXT
  • createdAt — DATETIME
  • modifiedAt — DATETIME
  • status — ENUM('PUBLIC','PRIVATE')

reservation

  • res_seq — BIGINT — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • res_status — ENUM
  • res_log — DATETIME
  • res_date — DATETIME — NOT NULL
  • res_people — INTEGER — NOT NULL
  • res_comment — TEXT

restaurant_image

  • image_id — INTEGER — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • image_url — VARCHAR(255)
  • image_type — ENUM
  • description — TEXT
  • uploadedAt — DATETIME

restaurant_info

  • restaurant_id — INTEGER — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • restaurant_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • description — TEXT
  • phone — VARCHAR(255) — NOT NULL
  • approvedAt — DATETIME — NOT NULL
  • openHour — INTEGER
  • closeHour — INTEGER
  • closedDay — INTEGER
  • createdAt — DATETIME
  • modifiedAt — DATETIME
  • review_total — INTEGER — NOT NULL
  • like_total — INTEGER — NOT NULL
  • zzim_total — INTEGER — NOT NULL

restaurant_like

  • like_seq — INTEGER — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • restaurant_id — INTEGER — NOT NULL

restaurant_status

  • request_seq — INTEGER — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • admin_seq — INTEGER — NOT NULL
  • Status — ENUM
  • comment — TEXT
  • updatedAt — DATETIME

restaurant_zzim

  • zzim_seq — INTEGER — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • zzim_date — DATETIME

visited

  • visit_seq — BIGINT — NOT NULL
  • member_seq — BIGINT — NOT NULL
  • restaurant_id — INTEGER — NOT NULL
  • visitedAt — DATETIME