멋쟁이 사자 자바 팀 프로젝트

테이블 (8)

Copy Of Theme park (CopyOftheme_park)

  • Other Parks id (other_parks_id) — INT(11) — 기본 키 — NOT NULL
  • Date (date) — DATETIME
  • Theme Type (theme_type) — VARCHAR(255)
  • Detail Type (detail_type) — VARCHAR(255)
  • Price (price) — INT(11)

Cruise (cruise)

  • Cruise id (cruise_id) — INT(11) — 기본 키 — NOT NULL
  • User id (user_id) — INT(11) — 외래 키 → USER.User id — NOT NULL
  • Cabin (cabin) — VARCHAR(255)
  • Date (date) — DATETIME
  • Price (price) — INT(11)

Flight (flight)

  • Flight id (flight_id) — INT(11) — 기본 키 — NOT NULL
  • User id (user_id) — INT(11) — 외래 키 → USER.User id — NOT NULL
  • Airline (airline) — VARCHAR(255)
  • Date (date) — DATETIME
  • Price (price) — INT(11)

Membership resort (membership_resort)

  • Membership resort id (membership_resort_id) — INT(11) — 기본 키 — NOT NULL
  • User id (user_id) — INT(11) — 외래 키 → USER.User id — NOT NULL
  • Admission (admission) — DATETIME
  • Check out (check_out) — DATETIME
  • Type (type) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Price (price) — INT(11)

Resort (resort)

  • Resort id (resort_id) — INT(11) — 기본 키 — NOT NULL
  • User id (user_id) — INT(11) — 외래 키 → USER.User id — NOT NULL
  • Admission (admission) — DATETIME
  • Check out (check_out) — DATETIME
  • Type (type) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Price (price) — INT(11)

Restaurant (restaurant)

  • Restaurant id (restaurant_id) — INT(11) — 기본 키 — NOT NULL
  • User id (user_id) — INT(11) — 외래 키 → USER.User id — NOT NULL
  • Date (date) — DATETIME
  • Baby seat (baby_seat) — INT(1)
  • Type (type) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Count people (count_people) — INT(11)

Theme park (theme_park)

  • Theme park id (theme_park_id) — INT(11) — 기본 키 — NOT NULL
  • Date (date) — DATETIME
  • Theme Type (theme_type) — VARCHAR(255)
  • Pass Type (pass_type) — VARCHAR(255)
  • Price (price) — INT(11)

USER (user)

  • User id (user_id) — INT(11) — 기본 키 — NOT NULL
  • Country (country) — VARCHAR(255)
  • Passport (passport) — INT(11)
  • Phone (phone) — INT(11)
  • ID (id) — VARCHAR(16)
  • Password (password) — VARCHAR(16)