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