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)