연세 철도주식회사 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)