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