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)