travel
Tables (12)
CITY (지역)
- cityid — int — Primary key — NOT NULL
- city_name (city-name) — varchar
- city — varchar
- load — varchar
- zipcode
COMPANY (회사)
- company_id — int — Primary key — NOT NULL
- name — varchar
- city — varchar
- load — varchar
- zipcode — varchar
- id (tourist_id) — int — Foreign key → TOURIST.id — NOT NULL
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL
- check_auth (check_auch) — boolean
COMPANY_DELETED (Untitled)
- company_deleted_id (company_deleted) — int — Primary key — NOT NULL
- reason — enum
- reason_detail — varchar
- deleted_date — date
- company_id — int — Foreign key → COMPANY.company_id — NOT NULL
ROLE (권한)
- id (role_id) — int — Primary key — NOT NULL
- role — varchar(255)
TOURIST (toruist)
- id — int — Primary key — NOT NULL
- name — varchar
- city — varchar
- load — varchar
- zipcode — varchar
- cityid — int — Foreign key → CITY.cityid — NOT NULL
TOURIST_REVIEW (관광지 후기)
- tourist_review_id — int — Primary key — NOT NULL
- title — varchar
- content — blob
- scroe (score) — float
- deleted — boolean
- date — date
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL
- id (id2) — int — Foreign key → TOURIST.id — NOT NULL
TOURIST_REVIEW_COMENT (관광지후기댓글)
- tourist_review_coment_id — int — Primary key — NOT NULL
- content — varchar
- Field
- Field2
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL
- tourist_review_id — int — Foreign key → TOURIST_REVIEW.tourist_review_id — NOT NULL
URESRS (유저)
- User_id (userId) — int — Primary key — NOT NULL
- name — varchar
- email — varchar
- password — varchar
- city — varchar
- load — varchar
- id (role_id) — int — Foreign key → ROLE.id — NOT NULL
USER_LIKE_CITY (지역 좋아요)
- id — int — Primary key — NOT NULL
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL
- cityid — int — Foreign key → CITY.cityid — NOT NULL
USER_VISIT_COMPANY (사용자업체방문)
- USER_VISIT_COMPANY_id — int — Primary key — NOT NULL
- date — date
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL
- company_id — int — Foreign key → COMPANY.company_id — NOT NULL
company_review (업체 후기)
- company_review_id — int — Primary key — NOT NULL
- title — varchar
- content — blob
- score — float
- deleted — boolean
- Field
- id (id2) — int — Foreign key → COMPANY.company_id — NOT NULL
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL
company_review_coment (업체후기 댓글)
- company_review_coment_id — int — Primary key — NOT NULL
- content — varchar
- Field
- company_review_id — int — Foreign key → company_review.company_review_id — NOT NULL
- User_id (userId) — int — Foreign key → URESRS.User_id — NOT NULL