Train
Tables (4)
TRAIN
- TRAIN_NUMBER — VARCHAR2(50) — Primary key — NOT NULL
- TRAIN_NAME (Key) — Primary key — NOT NULL
- TRAIN_LOCAL (TRAIN_LOACL) — VARCHAR2(50)
- TRAIN_LEAVE — VARCHAR2(50)
- TRAIN_ARRIVE — VARCHAR2(50)
- TRAIN_FREE — VARCHAR2(50)
- TRAIN_LOCAL2 (TRAIN_LOACL2) — VARCHAR2(50)
- TRAIN_PRICE — VARCHAR2(50)
- TRAIN_TIME — VARCHAR2(50)
- TRAIN_DAY — VARCHAR2(50)
TRAIN_MEMBER
- TRAIN_MEMBER_ID — VARCHAR2(50) — Primary key — NOT NULL
- TRAIN_MEMBER_PW (TRAIN_MEMVER_PW) — VARCHAR2(50)
- TRAIN_MEMVER_NAME — VARCHAR2(50)
- TRAIN_MEMVER_EMAIL — VARCHAR2(50)
- TRAIN_MEMVER_PHONE — VARCHAR2(50)
- TRAIN_MEMVER_ADDRESS — VARCHAR2(50)
- TRAIN_MEMVER_GENDER — VARCHAR2(50)
TRAIN_PAY
- TRAIN_MEMBER_ID (TRAIN_PAY_ID) — VARCHAR2(50) — Foreign key → TRAIN_MEMBER.TRAIN_MEMBER_ID — NOT NULL
- TRAIN_PAY_DAY — VARCHAR2(50)
- TRAIN_PAY_LOCAL — VARCHAR2(50)
- TRAIN_PAY_LOCAL2 — VARCHAR2(50)
- TRAIN_PAY_PRICE — VARCHAR2(50)
- TRAIN_PAY_SEAT — VARCHAR2(50)
TRAIN_SEAT
- TRAIN_SEAT_NUMBER — VARCHAR2(50) — Primary key — NOT NULL
- TRAIN_NUMBER — VARCHAR2(50) — Foreign key → TRAIN.TRAIN_NUMBER — NOT NULL
- TRAIN_NAME — VARCHAR2(50) — Foreign key → TRAIN.TRAIN_NAME — NOT NULL
- TRAIN_SEAT_RESERVED — CHAR(1)