1
Tables (27)
bookmark
- bookmark_id — BIGINT
- bookmark_created_at — DATETIME — NOT NULL
- bookmark_updated_at — DATETIME
- bookmark_deleted_at — DATETIME
- user_id — BIGINT
- memo_id — BIGINT
- rs_restaurant_id — BIGINT
cart
- cart_id — BIGINT
- user_id — BIGINT — NOT NULL
- rs_restaurant_id — BIGINT — NOT NULL
- queue_id — BIGINT
- cart_amount — INT — NOT NULL
- cart_created_at — DATETIME — NOT NULL
- cart_updated_at — DATETIME
- cart_deleted_at — DATETIME
- cart_status — ENUM('ACTIVE', 'ORDERED', 'CANCELLED') — NOT NULL
cart_item
- cart_item_id — BIGINT
- cart_item_amount — INT
- cart_id — BIGINT
- rs_menus_id — BIGINT
follow
- follow_id — BIGINT
- following_id — VARCHAR(255) — NOT NULL
- user_id — BIGINT
group
- => — mysql
- group_name — VARCHAR(255) — NOT NULL
- group_created_at — DATETIME — NOT NULL
- group_updated_at — DATE
- group_deleted_at — DATE
memo
- memo_id — BIGINT
- memo_content — VARCHAR(255)
- memo_created_at — DATETIME — NOT NULL
- memo_updated_at — DATETIME
- memo_deleted_at — DATETIME
payment
- payment_id — BIGINT
- payment_created_at — DATETIME
- payment_name — VARCHAR(255)
- payment_method — VARCHAR(255)
- payment_amount — VARCHAR(255)
- payment_size — VARCHAR(255)
- user_id — BIGINT
- rs_restaurant_id — BIGINT
- order_id — BIGINT
- reservation_id — BIGINT
- payment_type — ENUM('QUEUE', 'RESERVATION') — NOT NULL
pictures
- uuid — VARCHAR(255)
- path — VARCHAR(255)
- origin — VARCHAR(255)
- field — VARCHAR(255)
queue
- queue_id — BIGINT
- queue_number — INT — NOT NULL
- queue_date — DATE — NOT NULL
- queue_time — TIME — NOT NULL
- queue_state — VARCHAR(255) — NOT NULL
- queue_created_at — DATETIME — NOT NULL
- queue_updated_at — DATETIME
- queue_deleted_at — DATETIME
- is_prepaid — BOOLEAN — NOT NULL
- // — rs_restaurant_id
- user_id — BIGINT
queue_order
- (선결제 — 시에만
- queue_id — BIGINT — NOT NULL
- cart_id — BIGINT — NOT NULL
- total_amount — INT
- user_id — BIGINT — NOT NULL
- order_date_time — DATETIME
- order_status — VARCHAR(255)
- rs_restaurant_id — BIGINT
- payment_id — BIGINT
queue_order_item
- queue_order_item_id — BIGINT
- queue_order_item_amount — INT
- queue_order_item_price — INT
- rs_menu_id — BIGINT
- queue_order_id — BIGINT
rs_amenities
- rs_amenity_id — BIGINT
- rs_amenity_name — VARCHAR(255) — NOT NULL
rs_coordinates
- rs_coordinates_id — BIGINT
- restaurant_lat — FLOAT
- restaurant_long — FLOAT
- restaurant_addr — VARCHAR(255)
rs_cuisine_categories
- rs_cuisine_category_id — BIGINT
- rs_cuisine_category_name — VARCHAR(255) — NOT NULL
rs_document
- rs_document_id — BIGINT
- rs_document_certificate — VARCHAR(255)
- rs_document_business_id — VARCHAR(255)
rs_location_categories
- rs_location_id — BIGINT
- rs_location_name — VARCHAR(255)
rs_menus
- rs_menu_id — BIGINT
- rs_menu_name — VARCHAR(255) — NOT NULL
- rs_menu_desc — VARCHAR(255)
- rs_menu_price — VARCHAR(255) — NOT NULL
- rs_menu_isfeatured — BOOLEAN — NOT NULL
- rs_menu_appear — VARCHAR(255)
- rs_menu_photo_origin — VARCHAR(255)
- rs_menu_photo_path — VARCHAR(255)
- rs_menu_photo_name — VARCHAR(255)
- rs_menu_created_at — DATETIME — NOT NULL
- rs_menu_updated_at — DATETIME
- rs_menu_deleted_at — DATETIME
- rs_id — BIGINT
rs_news
- rs_news_id — BIGINT
- rs_news_content — VARCHAR(255)
- rs_news_published_created_at — DATETIME
- rs_news_updated_at — DATETIME
- rs_news_deleted_at — DATETIME
- rs_id — BIGINT
rs_reservation
- rs_reservation_id — BIGINT
- rs_reservation_party_size — INT — NOT NULL
- rs_reservation_date — DATE — NOT NULL
- rs_reservation_time — DATETIME — NOT NULL
- rs_reservation_request — VARCHAR(255)
- rs_reservation_state — VARCHAR(255) — NOT NULL
- rs_reservation_created_at — DATETIME — NOT NULL
- rs_reservation_updated_at — DATETIME
- rs_reservation_deleted_at — DATETIME
- rs_review_id — BIGINT
- rs_restaurant_id — BIGINT
- user_id — BIGINT
- payment_id — BIGINT
rs_restaurant
- rs_id — BIGINT
- rs_name — VARCHAR(255) — NOT NULL
- rs_phone — VARCHAR(255) — NOT NULL
- rs_park — VARCHAR(255)
- rs_time — VARCHAR(255)
- rs_state — VARCHAR(255)
- rs_review_count — VARCHAR(255)
- rs_bookmark_count — INT
- rs_avg_rate — INT
- rs_reservation_count — INT
- rs_coordinates_id — BIGINT
- rs_cuisine_categories_id — BIGINT
- rs_document_id — BIGINT
- rs_location_categories_id — BIGINT
rs_restaurant_amenities_mapping
- rs_restaurant_amenities_mapping_id — BIGINT
- rs_id — BIGINT
- rs_amenities_id — BIGINT
rs_review
- rs_review_id — BIGINT
- rs_review_rate — TINYINT
- rs_review_created_at — DATE — NOT NULL
- rs_review_state — VARCHAR(255)
- rs_review_like — BIGINT
- user_id — BIGINT — NOT NULL
- rs_id — BIGINT — NOT NULL
- rs_review_comment_id — BIGINT
rs_review_comment
- rs_comment_id — BIGINT
- rs_comment_content — VARCHAR(255) — NOT NULL
- rs_comment_state — VARCHAR(255)
- rs_comment_created_at — DATETIME — NOT NULL
- rs_comment_updated_at — DATETIME
- rs_comment_deleted_at — DATETIME
- rs_parent_comment_id — BIGINT
- rs_comment_depth — BIGINT
- rs_review_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- rs_id — BIGINT — NOT NULL
rs_table
- rs_table_id — BIGINT
- rs_table_size — INT
- rs_table_state — VARCHAR(255)
- rs_table_created_at — DATETIME — NOT NULL
- rs_table_updated_at — DATETIME
- rs_table_deleted_at — DATETIME
- rs_restaurant_id — BIGINT
user
- user_id — BIGINT
- user_email — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(255) — NOT NULL
- user_pw — VARCHAR(255) — NOT NULL
- user_phone — VARCHAR(50) — NOT NULL
- user_state — VARCHAR(50) — NOT NULL
- user_nick_name — VARCHAR(255) — NOT NULL
- user_birthday — DATE — NOT NULL
- user_gender — VARCHAR(10) — NOT NULL
- user_photo_origin — VARCHAR(255)
- user_photo_path — VARCHAR(255)
- user_photo_name — VARCHAR(255)
- user_grade — VARCHAR(50) — NOT NULL
- user_follower — INT
- user_following — INT
- user_auth — VARCHAR(255)
- user_created_at — DATETIME — NOT NULL
- user_updated_at — DATETIME
- user_deleted_at — DATETIME
- user_role_id — BIGINT
- cart_id — BIGINT
user_group_mapping
- user_group_mapping_id — BIGINT
- user_group_mapping_created_at — DATE — NOT NULL
- user_group_mapping_updated_at — DATE
- user_group_mapping_deleted_at — DATE
- user_id — BIGINT
- group_id — BIGINT
user_role
- role_name — VARCHAR(20)
- description — VARCHAR(100) — NOT NULL
- created_at — DATETIME