j
Tables (14)
card
- card_id(PK) (카드식별자) — int — Primary key — NOT NULL
- card_number (카드번호) — varchar
code
- code_id(PK) (코드식별자) — int — Primary key — NOT NULL
- code_group (코드그룹) — varchar
- code_value (코드값) — varchar
- code_name (코드내용) — varchar
contact
- contact_id(PK) (연락처식별자) — int — Primary key — NOT NULL
- contact_info (연락처) — varchar
- customer_id(FK) (고객식별자) — int — Foreign key → customer.customer_id(PK) — NOT NULL
- code_id(contact_type_cd)(FK) (연락처유형) — varchar — Foreign key → code.code_id(PK) — NOT NULL
cost_etc (cost_et)
- cost_etc_amount (기타비용) — int
- card_id(FK) (카드식별자) — int — Foreign key → card.card_id(PK) — NOT NULL
- reservation_id(FK) (예약식별자) — int — Foreign key → reservation.reservation_id(PK) — NOT NULL
- code_id(cost_item_cd)(FK) (기타비용항목) — varchar — Foreign key → code.code_id(PK) — NOT NULL
cost_guide
- guide_amount (가이드비용) — int
- reservation_id(FK) (예약식별자) — int — Foreign key → reservation.reservation_id(PK) — NOT NULL
- guide_id(FK) (가이드식별자) — int — Foreign key → guide.guide_id — NOT NULL
cost_vehicle
- vehicle_amount (차량비용) — int
- reservation_id(FK) (예약식별자) — int — Foreign key → reservation.reservation_id(PK) — NOT NULL
- vehicle_id(FK) (차량식별자) — int — Foreign key → vehicle.vehicle_id(PK) — NOT NULL
customer
- customer_id(PK) (고객식별자) — int — Primary key — NOT NULL
- customer_name (대표고객성함) — varchar
- customer_nationality (국적) — varchar
driver
- driver_id (차량식별자) — int
- driver_name (기사명) — varchar
- driver_phone (기사연락처) — varchar
guide
- guide_id (가이드식별자) — int — Primary key — NOT NULL
- guide_name_kor (가이드명(한글)) — varchar
- guide_name_eng (가이드명(영어)) — varchar
- guide_phone (가이드연락처) — varchar
payment
- payment_id(PK) (정산식별자) — int — Primary key — NOT NULL
- estimated_price_krw (견적가KRW) — decimal
- estimated_price_usd (견적가USD) — decimal
- estimated_exchange_krw (견적환율KRW) — decimal
- actual_payment_krw (실결제KRW) — decimal
- payment_exchange_krw (결제환율KRW) — decimal
- paypal_fee_rate (페이팔4.7%) — decimal
- card_fee_rate (카드3.5%) — decimal
- terminal_fee_rate (단말기3.5/3.6%) — decimal
- transfer_fee (송금수수료) — decimal
- paypal_eximbay_invoice_code (페이팔&엑심베이인보이스코드) — varchar
- payment_completed_date (결제완료일) — varchar
- card_type (카드종류) — varchar
- card_approval_number (카드승인번호) — varchar
- reservation_id(FK) (예약식별자) — int — Foreign key → reservation.reservation_id(PK) — NOT NULL
- code_id(payment_method_cd)(FK) (결제방법) — varchar — Foreign key → code.code_id(PK) — NOT NULL
- code_id(payment_status_cd)(FK) (결제상태) — varchar — Foreign key → code.code_id(PK) — NOT NULL
reservation
- reservation_id(PK) (예약식별자) — int — Primary key — NOT NULL
- reservation_route (경로) — char
- reservation_number (번호) — varchar
- reservation_code (예약코드) — varchar
- first_responder (최초응대자) — varchar
- first_response_datetime (최초응대일시) — datetime
- service_date (서비스일자) — datetime
- service_time (서비스시간) — datetime
- service_duration (이용시간) — int
- total_people (총인원수) — varchar
- stay_duration (체류기간) — date
- queue_staff (줄서기담당자) — varchar
- customer_passport_text (손님여권정보) — text
- memo_text (메모) — text
- detail_text (세부일정) — text
- customer_id(FK) (고객식별자) — int — Foreign key → customer.customer_id(PK) — NOT NULL
- code_id(reservation_status_cd)(FK) (상태) — varchar — Foreign key → code.code_id(PK) — NOT NULL
- code_id(reservation_region_cd)(FK) (지역) — varchar — Foreign key → code.code_id(PK) — NOT NULL
- code_id(reservation_inquiry_cd)(FK) (코드식별자3) — varchar — Foreign key → code.code_id(PK) — NOT NULL
- code_id(reservation_service_cd)(FK) (코드식별자4) — varchar — Foreign key → code.code_id(PK) — NOT NULL
- code_id(reservation_source_cd)(FK) (코드식별자5) — varchar — Foreign key → code.code_id(PK) — NOT NULL
settlement
- settlement_id(PK) (정산식별자) — int — Primary key — NOT NULL
- margin_travut (트래벗마진) — decimal
- margin_rate (마진율) — decimal
- settlement_date (정산날짜) — datetime
- reservation_id(FK) (예약식별자) — int — Foreign key → reservation.reservation_id(PK) — NOT NULL
supply_chain
- supply_chain (공급망) — varchar
- reservation_id(FK) (예약식별자) — int — Foreign key → reservation.reservation_id(PK) — NOT NULL
vehicle
- vehicle_id(PK) (차량식별자) — int — Primary key — NOT NULL
- vehicle_type (차종) — varchar
- plate_number (차량번호) — varchar