UpcomingPackageRelatedERD_Copy of winnerone_20240229
Tables (6)
Order
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (user_id) — BIGINT — NOT NULL — User 테이블의 id
- Field (package_id) — BIGINT — NOT NULL
- Field (departure_option_id) — BIGINT — NOT NULL
- Field (order_code) — VARCHAR(100) — NOT NULL — 주문번호
- Field (details) — TEXT — NOT NULL — 주문 상세 내역 json
- Field (total_price) — INT — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP
- Field (deleted_at) — TIMESTAMP
- Key (DUMMY) — BIGINT — Foreign key → Package.Key — NOT NULL — 연관관계 시각화용 더미 필드(실제 사용X)
- Key (DUMMY2) — BIGINT — Foreign key → User.Key — NOT NULL — 연관관계 시각화용 더미 필드(실제 사용X)
Package
- Key (id) — BIGINT — Primary key
- Field (departure_time) — TIME — NOT NULL — 첫 날 출발 시간
- Field (end_time) — TIME — NOT NULL — 마지막 날 일정 종료 시간
- Field (nation_id) — VARCHAR(30) — NOT NULL — Nation 테이블의 id
- Field (continent_id) — VARCHAR(30) — NOT NULL — Continent 테이블의 id
- Field (title) — VARCHAR(100) — NOT NULL
- Field (transportation) — VARCHAR(30) — NOT NULL
- Field (info) — VARCHAR(100) — NOT NULL — 패키지\n항공\n1박2일\n현지경비 KRW1,000
- Field (intro_image_url) — VARCHAR(500) — NOT NULL — 상품 소개 이미지 url
- Field (lodge_days) — INT — NOT NULL — 몇박
- Field2 (trip_days) — INT — NOT NULL — 몇일
- Field (inclusion_list) — TEXT — NOT NULL — 포함항목 json
- Field (exclusion_list) — TEXT — NOT NULL — 불포함항목 json
- Field (hotel_starts) — INT — NOT NULL — 호텔 별 개수
- Field (viewed_count) — INT — NOT NULL — 조회수
- Field (purchased_count) — INT — NOT NULL — 구매수
- Field (monthly_purchased_count) — INT — NOT NULL — 월별 구매수
- Field (shopping_count) — INT — NOT NULL — 쇼핑이 몇 회 포함되어 있는지
- Field (schedules) — TEXT — NOT NULL — 일정표 json
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP
- Field (deleted_at) — TIMESTAMP
Package_Departure_Option
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (package_id) — BIGINT — NOT NULL — Package 테이블의 id
- Field (departure_date) — DATE — NOT NULL — 출발일
- Field (adult_price) — INT — NOT NULL — 성인 1인 기준 총 가격
- Field (infant_price) — INT — NOT NULL — 소아 1인 기준 총 가격
- Field (baby_price) — INT — NOT NULL — 유아 1인 기준 총 가격
- Field (current_reservation_count) — INT — NOT NULL — 현재 예약된 인원
- Field2 (min_reservation_count) — INT — NOT NULL — 최소 출발 인원
- Field2 (max_reservation_count) — INT — NOT NULL — 최대 예약 가능 인원
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP
- Field (deleted_at) — TIMESTAMP
- Key (DUMMY) — BIGINT — Foreign key → Package.Key — NOT NULL — 연관관계 시각화용 더미 필드(실제 사용X)
Package_Image
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (package_id) — BIGINT — NOT NULL — Package 테이블의 id
- Field (image_url) — VARCHAR(300) — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP
- Field (deleted_at) — TIMESTAMP
- Key (DUMMY) — BIGINT — Foreign key → Package.Key — NOT NULL — 연관관계 시각화용 더미 필드(삭제 예정)
Package_Intro_Image
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (pakcage_id) — BIGINT — NOT NULL — package테이블의 id
- Field2 (image_url) — VARCHAR(300) — NOT NULL
- Field3 (created_at) — TIMESTAMP — NOT NULL
- Field4 (updated_at) — TIMESTAMP
- Field5 (deleted_at) — TIMESTAMP
- Key (DUMMY) — BIGINT — Foreign key → Package.Key — NOT NULL — 연관관계 시각화용 더미 필드(삭제 예정)
User
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (email) — VARCHAR(320) — NOT NULL
- Field (encrypted_password) — VARCHAR(300) — NOT NULL
- Field (phone) — VARCHAR(30) — NOT NULL
- Field (username) — VARCHAR(10) — NOT NULL — 실명
- Field (addr1) — VARCHAR(100) — 주소
- Field (addr2) — VARCHAR(100) — 상세 주소
- Field (postcord) — VARCHAR(10)
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP
- Field (deleted_at) — TIMESTAMP