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