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