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