BeginVegan
Tables (9)
Bookmark
- member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
- restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
Member
- member_email — VARCHAR(50) — Primary key — NOT NULL
- member_name — VARCHAR(50)
- member_point — INT
- member_role — VARCHAR(50)
Menu
- menu_no — INT — Primary key — NOT NULL
- restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
- menu_name — VARCHAR(100) — NOT NULL
- menu_price — INT — NOT NULL
- menu_category — VARCHAR(100) — NOT NULL
- menu_detail — VARCHAR(500)
- menu_photo_dir — VARCHAR(500)
Payment
- imp_uid — VARCHAR(50) — Primary key — NOT NULL
- member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
- reservation_no — INT — Foreign key → Reservation.reservation_no — NOT NULL
- payment_time — DATETIME — NOT NULL
- payment_price — INT — NOT NULL
- payment_status — VARCHAR(50) — NOT NULL
Point
- member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
- point_div — VARCHAR(20) — NOT NULL
- point_time — DATETIME — NOT NULL
- point_change — INT — NOT NULL
- point_result — INT — NOT NULL
Reservation
- reservation_no — INT — Primary key — NOT NULL
- member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
- restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
- reservation_time — DATETIME — NOT NULL
- reservation_visit_time — DATETIME — NOT NULL
- reservation_type — VARCHAR(50) — NOT NULL
- reservation_people — INT — NOT NULL
- reservation_discount — INT — NOT NULL
- reservation_total_price — INT — NOT NULL
- reservation_status — VARCHAR(50) — NOT NULL
Reservation_Menu
- reservation_no — INT — Foreign key → Reservation.reservation_no — NOT NULL
- menu_no — INT — Foreign key → Menu.menu_no — NOT NULL
- reservation_menu_count — INT
Restaurant
- restaurant_no — INT — Primary key — NOT NULL
- restaurant_name — VARCHAR(50) — NOT NULL
- restaurant_address — VARCHAR(500) — NOT NULL
- restaurant_address_gu — VARCHAR(100)
- restaurant_x — DOUBLE — NOT NULL
- restaurant_y — DOUBLE — NOT NULL
- restaurant_open — TIME
- restaurant_close — TIME
- restaurant_phone — VARCHAR(50)
- restaurant_detail — VARCHAR(1000)
- restaurant_avg_price — INT
- restaurant_table — INT — NOT NULL
- restaurant_table_member — INT — NOT NULL
- restaurant_vegan_level — INT — NOT NULL
- restaurant_photo_dir — VARCHAR(500)
- restaurant_star — DOUBLE — NOT NULL
Review
- review_no — INT — Primary key — NOT NULL
- reservation_no — INT — Foreign key → Reservation.reservation_no — NOT NULL
- restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
- member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
- review_star — INT — NOT NULL
- review_content — VARCHAR(1000)
- review_time — DATETIME — NOT NULL
- review_photo_dir — VARCHAR(500)