멋쟁이 사자 자바 팀 프로젝트
테이블 (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)