연세 철도주식회사 relational schema

테이블 (4)

Engineer

  • ID — INT — 기본 키 — NOT NULL
  • Headquarter.ID — INT — 외래 키 → Headquarter.ID — NOT NULL
  • year — INT
  • variety — INT
  • amount — INT

Headquarter

  • ID — INT — 기본 키 — NOT NULL
  • Name — VARCHAR(144)
  • Planet — VARCHAR(144)
  • Continent — VARCHAR(144)
  • ManagerName (MangerName) — VARCHAR(144)
  • Budget — INT

Line

  • ID — INT — 기본 키 — NOT NULL
  • Name — VARCHAR(144)
  • BuiltYear — INT
  • Capacity — INT

Station

  • ID — INT — 기본 키 — NOT NULL
  • Headquarter.ID — INT — 외래 키 → Headquarter.ID — NOT NULL
  • Name — VARCHAR(144)
  • Address — VARCHAR(144)
  • Tel — VARCHAR(144)
  • ManagerName — VARCHAR(144)
  • Budget — VARCHAR(144)