table

Tables (28)

bookmark (관심식당)

  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • memo_id (메모id) — int — Foreign key → memo.memo_id — NOT NULL
  • user_role_id (유저권한id) — int — Foreign key → user.user_role_id — NOT NULL
  • bookmark_created_at (등록일) — date
  • bookmark_updated_at (수정일) — date
  • bookmark_deleted_at (삭제일) — date
  • Field

cart (장바구니)

  • cart_id (장바구니id) — String — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • basket_amount (메뉴수량) — int
  • basket_created_at (등록일시) — datetime
  • basket_updated_at (수정일시) — datetime
  • basket_deleted_at (삭제일시) — datetime
  • Field

cart_item (장바구니아이템)

  • cart_item_id (장바구니아이템id) — int — Primary key — NOT NULL
  • cart_id (장바구니id) — String — Foreign key → cart.cart_id — NOT NULL
  • rs_menu_id (메뉴id) — int — Foreign key → rs_menus.rs_menu_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_menus.rs_id — NOT NULL
  • cart_item_amount (장바구니아이템수량) — int
  • Field

follow (팔로우)

  • follow_id (팔로우id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • following_id (팔로잉id) — varchar
  • Field

group (모임)

  • group_id (모임id) — int — Primary key — NOT NULL
  • group_name (모임이름) — varchar
  • group_created_at (등록일) — date
  • group_update_at (수정일) — date
  • group_deleted_at (삭제일) — date
  • Field

memo (메모)

  • memo_id (메모id) — int — Primary key — NOT NULL
  • memo_content (메모내용) — varchar
  • created_at (등록일) — date
  • updated_at (수정일) — date
  • deleted_at (삭제일) — date
  • Field

payment (결제)

  • payment_id (결제id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_reservation_id (식당예약id) — int — Foreign key → rs_reservations.rs_reservation_id — NOT NULL
  • queue_order_id (줄서기주문id) — int — Foreign key → queue_order.queue_order_id — NOT NULL
  • payment_created_at (결제일) — dateTime
  • payment_name (결제명) — varchar
  • payment_method (결제수단) — varchar
  • payment_amount (결제금액) — int
  • payment_state (결제상태) — char
  • payment_type (주문인지예약인지) — char
  • Field2

pictures (사진)

  • uuid (파일명) — varchar — Primary key — NOT NULL
  • path (경로) — varchar
  • origin (원본) — varchar
  • Field (분류) — char
  • Field

queue (줄서기)

  • queue_id (줄서기id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • queue_number (줄서기인원수) — int
  • queue_date (줄서기날짜) — date
  • queue_time (줄서기시간) — time
  • queue_state (줄서기상태) — char
  • queue_created_at (등록일시) — datetime
  • queue_updated_at (수정일시) — datetime
  • queue_deleted_at (삭제일시) — datetime

queue_order (줄서기주문)

  • queue_order_id (줄서기주문id) — int — Primary key — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • total_amount (총수량) — int
  • order_datetime (주문일시) — timestamp
  • order_status (주문상태) — char
  • Field

queue_order_items (줄서기주문아이템)

  • queue_order_item_id (줄서기주문아이템id) — int — Primary key — NOT NULL
  • queue_order_id (줄서기주문id) — int — Foreign key → queue_order.queue_order_id — NOT NULL
  • rs_menu_id (메뉴id) — int — Foreign key → rs_menus.rs_menu_id — NOT NULL
  • queue_order_item_amount (줄서기주문아이템수량) — int
  • queue_order_item_price (줄서기주문아이템가격) — int
  • Field

review_declare (리뷰신고)

  • review_declare_id (리뷰신고id) — int — Primary key — NOT NULL
  • review_id (리뷰id) — int — Foreign key → rs_reviews.rs_review_id — NOT NULL
  • u_id (유저id) — int — Foreign key → rs_reviews.user_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_reviews.rs_id — NOT NULL
  • rs_reservation_id (식당예약id) — int — Foreign key → rs_reviews.rs_reservation_id — NOT NULL
  • review_declare_content (리뷰신고사유) — varchar
  • review_declare_created_at (리뷰신고일) — date
  • review_declare_state (리뷰신고상태) — char
  • Field

rs_amenities (식당편의시설코드)

  • rs_amenity_id (편의시설코드id) — String — Primary key — NOT NULL
  • rs_amenity_name (편의시설이름) — String

rs_coordinates (식당좌표)

  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • restaurant_lat (식당위도) — int
  • restaurant_long (식당경도) — int
  • restaurant_addr (식당도로명주소) — varchar
  • Field

rs_cuisine_categories (식당종류카테고리)

  • rs_cuisine_category_id (종류카테고리id) — int — Primary key — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_cuisine_category_name (종류이름) — varchar
  • Field

rs_documents (식당상세서류)

  • rs_document_id (식당서류id) — String — Primary key — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_document_certificate (식당사업등록증) — varchar
  • rs_document_business_id (식당사업자번호) — int
  • Field

rs_location_categories (식당위치카테고리)

  • rs_location_id (위치카테고리id) — int — Primary key — NOT NULL
  • rs_id (식당) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_location_name (위치이름) — varchar
  • Field

rs_menus (식당메뉴)

  • rs_menu_id (메뉴id) — int — Primary key — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_menu_name (메뉴이름) — varchar
  • rs_menu_desc (메뉴설명) — varchar
  • rs_menu_price (메뉴가격) — varchar
  • rs_menu_state (메뉴상태) — boolean — 시즌 메뉴나, 메뉴가 바뀔 경우 노출 여부를 상태를 통해서 변경할 수 있음
  • rs_menu_appear (메뉴노출여부) — boolean
  • rs_menu_photo_origin (식당메뉴사진원본명) — varchar
  • rs_menu_photo_path (식당메뉴사진경로명) — varchar
  • rs_menu_photo_name (식당메뉴사진이름) — varchar
  • rs_menu_created_at (등록일) — date
  • rs_menu_updated_at (수정일) — date
  • rs_menu_deleted_at (삭제일) — date
  • Field

rs_news (식당소식)

  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_news_content (식당소식내용) — varchar
  • rs_news_published_at (작성일) — date
  • rs_news_updated_at (수정일) — date
  • rs_news_deleted_at (삭제일) — date
  • Field

rs_reservations (예약)

  • rs_reservation_id (식당예약id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_reservation_party_size (인원수) — int
  • rs_reservation_date (예약일) — date
  • rs_reservation_time (예약시간) — time
  • rs_reservation_request (예약요청사항) — varchar
  • rs_reservation_state (예약상태) — char
  • rs_reservation_created_at (등록일) — date
  • rs_reservation_updated_at (수정일) — date
  • rs_reservation_deleted_at (삭제) — date
  • Field

rs_restaurant (식당)

  • rs_id (식당id) — int — Primary key — NOT NULL
  • rs_name (식당이름) — varchar
  • rs_phone (식당연락처) — varchar
  • rs_park (식당주차) — varchar
  • rs_time (식당영업시간) — varchar — 상세정보에 들어갈 단순 영업시간설명
  • rs_state (식당상태) — char — 식당 등록시, 식당등록대기중, 식당등록확인중, 식당등록완료, 폐업 등 식당에 대한 상태
  • rs_review_count (식당리뷰개수) — int
  • rs_bookmark_count (식당관심개수) — int
  • rs_avg_rate (식당평균평점) — int
  • rs_reservation_count (식당예약횟수) — int
  • Field

rs_restaurants_amenities_mapping (식당편의시설맵핑)

  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_amenity_id (편의시설코드id) — String — Foreign key → rs_amenities.rs_amenity_id — NOT NULL

rs_review_comments (리뷰댓글)

  • rs_comment_id (리뷰댓글id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • rs_review_id (리뷰id) — int — Foreign key → rs_reviews.rs_review_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_reviews.rs_id — NOT NULL
  • rs__comment_created_at (리뷰댓글작성일) — date
  • rs_comment_content (리뷰댓글내용) — text
  • rs_comment_state (리뷰댓글상태) — char
  • rs_comment_created_at (등록일) — datetime
  • rs_comment_updated_at (수정일) — date
  • rs_comment_deleted_at (삭제일) — date
  • rs_parent_comment_id (부모댓글(대댓글용)) — int
  • rs_comment_depth (댓글깊이(대댓글구분용)) — int
  • Field
  • review_re_id (리뷰댓글id2) — int — Foreign key → rs_review_comments.rs_comment_id — NOT NULL
  • u_id (유저id2) — int — Foreign key → rs_review_comments.user_id — NOT NULL
  • rs_review_id (리뷰id2) — int — Foreign key → rs_review_comments.rs_review_id — NOT NULL
  • rs_id (식당id2) — int — Foreign key → rs_review_comments.rs_id — NOT NULL

rs_reviews (리뷰)

  • rs_review_id (리뷰id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_reservation_id (식당예약id) — int — Foreign key → rs_reservations.rs_reservation_id — NOT NULL
  • rs_review_content (리뷰내용) — varchar
  • rs_review_rate (별점)
  • rs_review_created_at (작성일) — date
  • rs_review_state (리뷰상태) — char
  • rs_review_like (리뷰좋아요) — int
  • Field

rs_tables (테이블관리)

  • rs_table_id (테이블번호) — String — Primary key — NOT NULL
  • rs_id (식당id) — int — Foreign key → rs_restaurant.rs_id — NOT NULL
  • rs_table_size (테이블크기) — int
  • rs_table_state (테이블상태) — char — 테이블이 공석인지 사용중인지 확인
  • rs_table_created_at (등록일) — date
  • rs_table_updated_at (수정일) — date
  • rs_table_deleted_at (삭제일) — date
  • Field

user (멤버)

  • user_id (유저id) — int — Primary key — NOT NULL
  • user_role_id (유저권한id) — int — Foreign key → user_role.user_role_id — NOT NULL
  • user_email (이메일) — varchar
  • user_name (이름) — varchar
  • user_pw (비밀번호) — varchar
  • user_phone (연락처) — varchar
  • user_state (상태) — char
  • user_nickname (닉네임) — varchar
  • user_birth (생일) — date
  • user_gender (성별) — char
  • user_photo_origin (프로필사진원본명) — varchar
  • user_photo_path (프로필사진경로명) — varchar
  • user_photo_name (프로필사진이름) — varchar
  • user_grade (등급) — char — 블랙유저, 좋은유저구분
  • user_follower (팔로워수) — int
  • user_following (팔로잉수) — int
  • user_auth (권한) — char
  • user_created_at (가입일) — date
  • user_updated_at (수정일) — date
  • user_deleted_at (탈퇴일) — date
  • Field

user_group_mapping (유저-모임)

  • user_id (유저id) — int — Foreign key → user.user_id — NOT NULL
  • group_id (모임id) — int — Foreign key → group.group_id — NOT NULL
  • group_mapping_created_at (등록일) — date
  • group_mapping_updated_at (수정일) — date
  • group_mapping_deleted_at (삭제일) — date
  • Field

user_role (유저권한)

  • user_role_id (유저권한id) — int — Primary key — NOT NULL
  • user_role__name (유저권한이름) — varchar
  • user_role_created_at (등록일) — date
  • user_role_updated_at (수정일) — date
  • user_role_deleted_at (삭제일) — date
  • Field