CapstonProject2
Tables (12)
Accommodation
- accommodation_id — INT — Primary key — NOT NULL
- trip_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- check_in_time — TIME
- check_out_time — TIME
- booking_confirmation — VARCHAR(255)
- created_at — TIMESTAMP
DailySchedule
- daily_schedule_id — INT — Primary key — NOT NULL
- schedule_id2 — INT — NOT NULL
- day_number — INT — NOT NULL
- date — DATE — NOT NULL
- created_at — TIMESTAMP
- start_time — TIME
- end_time — TIME
- place_id — INT
- notes — TEXT
Destination
- destination_id — INT — Primary key — NOT NULL
- aviation_info — ENUM('Necessary', ' Unnecessary') — NOT NULL
- visa_info — ENUM('Necessary', ' Unnecessary') — NOT NULL
- voltage — INT
- time_difference — INT
- picture — VARCHAR(50)
Images
- id — VARCHAR(255)
- placeId — VARCHAR(255)
- imageUrl — VARCHAR(255) — NOT NULL
- isThumbnail — BOOLEAN — NOT NULL
IntroDetail
- placeId — VARCHAR(255)
- openTime — VARCHAR(255)
- closeTime — VARCHAR(255)
- restDate — VARCHAR(255)
- useFee — VARCHAR(255)
- parking — VARCHAR(255)
- infoCenter — VARCHAR(255)
- availableLanguage — VARCHAR(255)
- location — VARCHAR(255)
Place
- place_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10,8)
- longitude — DECIMAL(11,8)
- contentType — ENUM( 'SIGHTSEEING', 'CULTURAL', 'FESTIVAL', 'COURSE', 'LEPORTS', 'ACCOMMODATION', 'SHOPPING', 'RESTAURANT' ) — NOT NULL
- isIndoor — BOOLEAN
- description — TEXT
- created_at — TIMESTAMP
- mapX — INT
- mapY — INT
- keyword — VARCHAR(50)
- type — VARCHAR(50)
- areaCode — INT
- address — VARCHAR(50)
- image — VARCHAR(50)
- mapLevel — INT
- tel — VARCHAR(50)
Place1
- id — VARCHAR(255)
- title — VARCHAR(255) — NOT NULL
- contentType — ENUM( 'SIGHTSEEING', 'CULTURAL', 'FESTIVAL', 'COURSE', 'LEPORTS', 'ACCOMMODATION', 'SHOPPING', 'RESTAURANT' ) — NOT NULL
- category1 — VARCHAR(255)
- category2 — VARCHAR(255)
- category3 — VARCHAR(255)
- description — TEXT
- address — VARCHAR(255)
- zipcode — VARCHAR(20)
- tel — VARCHAR(50)
- homepage — VARCHAR(255)
- areaName — VARCHAR(255)
- countryCode — VARCHAR(2)
Schedule
- schedule_id — INT — Primary key — NOT NULL
- trip_id2 — INT — NOT NULL
- daily_schedule_id — INT
- accommodation_id — INT
- start_day — TIME — NOT NULL
- end_day — TIME — NOT NULL
- sequence_number — INT — NOT NULL
- created_at — TIMESTAMP
Tag
- keyword — VARCHAR(255) — Primary key — NOT NULL
- placeId — VARCHAR(255)
TravelEssentials
- essentials_id — INT — Primary key — NOT NULL
- trip_id2 — INT — NOT NULL
- mobile_plan — ENUM('Local SIM', 'Pocket WiFi', 'Roaming', 'None') — NOT NULL
- has_passport — BOOLEAN
- has_visa — BOOLEAN
- has_insurance — BOOLEAN
- currency_exchange_plan — TEXT
- created_at — TIMESTAMP
Trip
- trip_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- destination_id — INT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- companion_type — ENUM('Solo', 'Friends', 'Partner', 'Family', 'Business', 'Other') — NOT NULL
- budget — DECIMAL(10,2)
- created_at — TIMESTAMP
- concept — ENUM('Sightseeing', 'Food', 'Experience', 'Shopping', 'Learning')
- pace — ENUM('Relaxed', 'Packed')
- arrival_transport — ENUM('Ship', 'Car', 'Train', 'Plane')
- local_transport — ENUM('Car', 'Train', 'Subway')
- traffic_pass — Boolean
- rent_car — Boolean
- usim — Boolean
- pocket_wifi — Boolean
- passport — Boolean
- visa — Boolean
- insurance — Boolean
User
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — ENUM('M', 'F', 'Other')
- birth_date — DATE
- created_at — TIMESTAMP