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 (종착지)