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