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