bus_database
Tables (3)
Bus (버스)
- id (버스ID(PK)) — Long — Primary key — NOT NULL
- company_id (회사ID(FK)) — Long — Foreign key → Company.id — NOT NULL
- route_id (노선ID(FK)) — Long — Foreign key → Route.id — NOT NULL
- bus_number (버스번호) — String
- type (버스종류) — String
Company (회사)
- id (회사ID(PK)) — Long — Primary key — NOT NULL
- company_name (회사명) — String
- phone_number (고객센터) — String
- region (지역) — String
Route (노선)
- id (노선ID(PK)) — Long — Primary key — NOT NULL
- route_name (노선번호) — String
- start_point (출발지) — String
- end_point (종착지)