Highway Rest

Tables (9)

Brand Shop (Untitled7)

  • 브랜드_id (brand_id) — IntegerField — Primary key — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 브랜드명 (brand_name) — CharField(100)
  • 브랜드 영업시간 (brand_opentime) — CharField(100)
  • 브랜드 종료시간 (brand_closetime) — CharField(100)
  • 브랜드 정보 (brand_info) — CharField(100)

Comment (Untitled4)

  • 댓글_id (commend_id) — IntegerField — Primary key — NOT NULL
  • 유저 (user_id) — IntegerField — Foreign key → User.유저 — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 내용 (comment_contents) — CharField(100)
  • 작성시간 (comment_create) — DateField
  • 수정시간 (comment_edit) — DateField

Ex_Food (Untitled5)

  • EX_Food (ex_id) — IntegerField — Primary key — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 대표음식이름 (ex_name) — CharField(100)
  • 음식설명 (ex_info) — CharField(100)
  • 음식 가격 (ex_price) — CharField(100)
  • 음식 이미지 (ex_img) — CharField(100)

Rest Area (Untitled2)

  • 휴게소_id (rest_id) — IntegerField — Primary key — NOT NULL
  • 휴게소이름 (rest_name) — CharField(100)
  • 휴게소주소 (rest_adress) — CharField(100)
  • 고속도로 (rest_high) — CharField(100)
  • 고속도로방향 (rest_highdirect) — CharField(100)
  • 휴게소좌표 (rest_coordinate) — CharField(100)
  • 티맵도로명 (rest_tmap) — CharField(100)
  • 정비소 (rest_fix) — Boolean
  • 트럭 (rest_truck) — Boolean
  • 수유실 (rest_feeding) — Boolean
  • 수면실 (rest_sleep) — Boolean
  • 샤워실 (rest_shower) — Boolean
  • 세탁실 (rest_laundary) — Boolean
  • 약국 (rest_drug) — Boolean

Rest Menu (Untitled3)

  • 메뉴_id (menu_id) — IntegerField — Primary key — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 메뉴이름 (menu_name) — CharField(100)
  • 메뉴가격 (menu_price) — IntegerField
  • 추천메뷰 (menu_best) — CharField(100)

Rest_Gas (Untitled9)

  • 주유소_id (gas_id) — IntegerField — Primary key — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 주유소명 (gas_name) — CharField(100)
  • lpg여부 (gas_lpg) — CharField(100)
  • 주유소 전화번호 (gas_tel) — CharField(100)

Rest_Theme (Untitled6)

  • 테마_id (theme_id) — IntegerField — Primary key — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 테마소개 (theme_detail) — CharField(100)
  • 테마명 (theme_name) — CharField(100)

Top5 (Untitled8)

  • Top5_id (top_id) — IntegerField — Primary key — NOT NULL
  • 휴게소_id (rest_id) — IntegerField — Foreign key → Rest Area.휴게소_id — NOT NULL
  • 매장명 (top_shop) — CharField
  • 상품명 (top_item) — CharField
  • 순위 (top_rank) — IntegerField

User (Untitled)

  • 유저 (user_id) — IntegerField — Primary key — NOT NULL
  • 아이디 (user_email) — CharField(100)
  • 비밀번호 (user_password) — CharField(100)
  • 닉네임 (user_nickname) — CharField(100)