kobus again

Tables (22)

ADTN_TIMDTE

  • FP_CPN_NO — VARCHAR(20)
  • TIM_DTE — DATE

ARRIVAL

  • ARRID — VARCHAR(40) — Primary key — NOT NULL
  • REGID — VARCHAR(40) — Foreign key → REGION.REGID

BOARD

  • BRDID — NUMBER — Primary key — NOT NULL
  • KUSID — VARCHAR(40) — Foreign key → KOBUSUSER.KUSID
  • BRDTITLE — VARCHAR(200)
  • BRDCONTENT — TEXT
  • BRDDATE — TIMESTAMP
  • BRDVIEWS — NUMBER

BRDCOMMENT

  • BRDID (BRDID2) — NUMBER — Foreign key → BOARD.BRDID — NOT NULL
  • BCMID — NUMBER — NOT NULL
  • BRDID — NUMBER — NOT NULL
  • KUSID — VARCHAR(40)
  • CONTENT — TEXT
  • CMTDATE — TIMESTAMP

BUS

  • BUSID — VARCHAR(40) — Primary key — NOT NULL
  • BUSNO — NUMBER — NOT NULL
  • BUSGRADE — VARCHAR(20) — NOT NULL
  • BUSSEATS — NUMBER — NOT NULL
  • COMID — VARCHAR(40) — Foreign key → COMPANY.COMID — NOT NULL

BUSSCHEDULE

  • BSHID — VARCHAR(40) — Primary key — NOT NULL
  • ROUID — VARCHAR(40) — Foreign key → ROUTE.ROUID — NOT NULL
  • BUSID — VARCHAR(40) — Foreign key → BUS.BUSID — NOT NULL
  • DEPARTUREDATE — TIMESTAMP — NOT NULL
  • ARRIVALDATE — TIMESTAMP — NOT NULL
  • DURMIN — NUMBER — NOT NULL
  • REMAINSEATS — NUMBER — NOT NULL
  • STATUS — VARCHAR(20) — NOT NULL
  • CANCELFEE — NUMBER
  • CANCELABLE — CHAR(1) — NOT NULL
  • ADULTFARE — NUMBER — NOT NULL
  • STUFARE — NUMBER — NOT NULL
  • CHILDFARE — NUMBER — NOT NULL

COMPANY

  • COMID — VARCHAR(40) — Primary key — NOT NULL
  • COMNAME — VARCHAR(50) — NOT NULL
  • REGNUMBER — NUMBER — NOT NULL
  • COMPHONE — VARCHAR(20) — NOT NULL
  • COMADDR — VARCHAR(100) — NOT NULL

CUSTOMERINFO

  • CIFID — VARCHAR(40) — Primary key — NOT NULL
  • CIFTEL — VARCHAR(11)
  • RESIDENTID — NUMBER

DEPARTURE

  • DEPID — VARCHAR(40) — Primary key — NOT NULL
  • REGID — VARCHAR(40) — Foreign key → REGION.REGID

FREE_PASS_OPTION

  • ADTN_PRD_SNO — VARCHAR(10) — Primary key — NOT NULL
  • ADTN_PRD_USE_CLS_CD — VARCHAR(10)
  • ADTN_PRD_USE_CLS_NM — VARCHAR(50)
  • ADTN_PRD_USE_PSB_DNO — NUMBER
  • ADTN_PRD_USE_NTKN_CD — VARCHAR(10)
  • ADTN_PRD_USE_NTKN_NM — VARCHAR(50)
  • WKD_WKE_NTKN_CD — VARCHAR(10)
  • WKD_WKE_NTKN_NM — VARCHAR(50)
  • TEMP_ALCN_TISSU_PSB_YN — CHAR(1)
  • ADTN_DC_YN — CHAR(1)
  • AMOUNT — NUMBER

FREE_PASS_PAYMENT

  • FREE_PASS_PAYMENT_ID — NUMBER — Primary key — NOT NULL
  • ADTN_PRD_SNO — VARCHAR(10) — Foreign key → FREE_PASS_OPTION.ADTN_PRD_SNO — NOT NULL
  • IMP_UID — VARCHAR(40)
  • MERCHANT_UID — VARCHAR(40)
  • PAY_METHOD — VARCHAR(20)
  • AMOUNT — NUMBER
  • PAY_STATUS — VARCHAR(20)
  • PG_TID — VARCHAR(100)
  • PAID_AT — DATE
  • REG_DT — DATE
  • STARTDATE — DATE
  • KUSID — VARCHAR(40) — Foreign key → KOBUSUSER.KUSID — NOT NULL

KOBUSUSER

  • KUSID — VARCHAR(40) — Primary key — NOT NULL
  • TEL — VARCHAR(11)
  • SUBEMAIL — VARCHAR(255)
  • ID — VARCHAR(255)
  • PASSWD — VARCHAR(255)
  • BIRTH — DATE
  • GENDER — NUMBER(1)
  • RANK — VARCHAR(255) — NOT NULL
  • MIL — NUMBER(10) — NOT NULL
  • STATUS — VARCHAR(1) — NOT NULL
  • JOINDATE — DATE

PASS_DETAIL

  • ADTN_PRD_SNO — VARCHAR(10) — Primary key — NOT NULL
  • ADTN_PRD_USE_CLS_CD — VARCHAR(2)
  • ADTN_PRD_USE_CLS_NM — VARCHAR(40)
  • ADTN_PRD_USE_PSB_DNO — VARCHAR(10)
  • ADTN_PRD_USE_NTKN_CD — VARCHAR(2)
  • ADTN_PRD_USE_NTKN_NM — VARCHAR(20)
  • WKD_WKE_NTKN_CD — VARCHAR(2)
  • WKD_WKE_NTKN_NM — VARCHAR(50)
  • PRICE — NUMBER(10)

PASS_ROUTE

  • ROUTE_ID — VARCHAR(10) — Primary key — NOT NULL
  • ADTN_DEPR_NM — VARCHAR(50)
  • ADTN_ARVL_NM — VARCHAR(50)
  • ADTN_DEPR_CD — VARCHAR(3)
  • ADTN_ARVL_CD — VARCHAR(3)
  • DEPR_NM — VARCHAR(50)
  • ARVL_NM — VARCHAR(50)
  • ADTN_PRD_SELL_STT_DT — VARCHAR(8)

PAYMENT

  • PAYMENT_ID — NUMBER — Primary key — NOT NULL
  • IMP_UID — VARCHAR(40)
  • MERCHANT_UID — VARCHAR(40)
  • PAY_METHOD — VARCHAR(20)
  • AMOUNT — NUMBER
  • PAY_STATUS — VARCHAR(20)
  • PG_TID — VARCHAR(100)
  • PAID_AT — DATE
  • REG_DT — DATE
  • STARTDATE — DATE
  • KUSID — VARCHAR(40) — Foreign key → KOBUSUSER.KUSID — NOT NULL
  • ADTN_PRD_SNO — VARCHAR(10) — Foreign key → PASS_DETAIL.ADTN_PRD_SNO
  • ROUTE_ID — VARCHAR(10) — Foreign key → PASS_ROUTE.ROUTE_ID

REGION

  • REGID — VARCHAR(40) — Primary key — NOT NULL
  • REGNAME — VARCHAR(40)
  • SIDOCODE — VARCHAR(40) — NOT NULL

RESERVATION

  • RESID — VARCHAR(40) — Primary key — NOT NULL
  • BSHID — VARCHAR(40) — Foreign key → BUSSCHEDULE.BSHID
  • SEATID — VARCHAR(40) — Foreign key → SEAT.SEATID
  • KUSID — VARCHAR(40) — Foreign key → KOBUSUSER.KUSID
  • RIDEDATE — TIMESTAMP — NOT NULL
  • RESVDATE — TIMESTAMP — NOT NULL
  • RESVSTATUS — VARCHAR(20) — NOT NULL
  • RESVTYPE — VARCHAR(20)
  • QRCODE — NUMBER — NOT NULL
  • MILEAGE — NUMBER — NOT NULL
  • SEATABLE — CHAR(1)

RESERVATION_PAYMENT

  • RESERVATION_PAYMENT_ID — NUMBER — Primary key — NOT NULL
  • RES_ID — VARCHAR(40) — Foreign key → RESERVATION.RESID — NOT NULL
  • IMP_UID — VARCHAR(40)
  • MERCHANT_UID — VARCHAR(40)
  • PAY_METHOD — VARCHAR(20)
  • AMOUNT — NUMBER
  • PAY_STATUS — VARCHAR(20)
  • PG_TID — VARCHAR(100)
  • PAID_AT — DATE
  • REG_DT — DATE
  • KUSID — VARCHAR(40) — Foreign key → KOBUSUSER.KUSID — NOT NULL
  • PAYMENT_ID — NUMBER — Foreign key → PAYMENT.PAYMENT_ID
  • FREE_PASS_PAYMENT_ID — NUMBER

RESERVEDSEATS

  • RESID — VARCHAR(20) — Primary key — NOT NULL
  • SEATID — VARCHAR(20) — Primary key — NOT NULL
  • BSHID — VARCHAR(20) — Foreign key → BUSSCHEDULE.BSHID
  • KUSID — VARCHAR(20) — Foreign key → KOBUSUSER.KUSID
  • SEATTYPE — VARCHAR(20)

ROUTE

  • ROUID — VARCHAR(40) — Primary key — NOT NULL
  • COMID — VARCHAR(40) — Foreign key → COMPANY.COMID — NOT NULL
  • ARRID — VARCHAR(40) — Foreign key → ARRIVAL.ARRID
  • DEPID — VARCHAR(40) — Foreign key → DEPARTURE.DEPID
  • DURATION — NUMBER — NOT NULL

SEAT

  • SEATID — VARCHAR(40) — Primary key — NOT NULL
  • BUSID — VARCHAR(40) — Foreign key → BUS.BUSID — NOT NULL
  • SEATNO — NUMBER — NOT NULL
  • SEATTYPE — VARCHAR(20) — NOT NULL
  • SEATABLE — CHAR(1) — NOT NULL

TERMS

  • TERMS_ID — NUMBER — Primary key — NOT NULL
  • TERMS_TYPE — VARCHAR(20) — NOT NULL
  • TITLE — VARCHAR(100) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • REG_DATE — DATE