subway

테이블 (9)

공중화장실 (Public_Restrooms)

  • restroom_id (PK) — INT — 기본 키 — NOT NULL
  • location (Field) — VARCHAR(100)
  • ground_type (Field2) — VARCHAR(10)
  • gate_type (Field3) — VARCHAR(10)
  • station_id (FK) — INT — 외래 키 → 역.station_id — NOT NULL

물품보관함 (Lockers)

  • locker_id (PK) — INT — 기본 키 — NOT NULL
  • locker_name (Field) — VARCHAR(50)
  • location (Field2) — VARCHAR(100)
  • small_count (Field3) — INT
  • medium_count (Field4) — INT
  • large_count (Field5) — INT
  • station_id (FK) — INT — 외래 키 → 역.station_id — NOT NULL

승차 인원 (Boarding_Count)

  • station_id (PFK) — INT — 외래 키 → 역.station_id — NOT NULL
  • boarding_0400_0459 (Field) — INT
  • boarding_0500_0559 (Field2) — INT
  • boarding_0600_0659 (Field3) — INT
  • boarding_0700_0759 (Field4) — INT
  • boarding_0800_0859 (Field5) — INT
  • boarding_0900_0959 (Field6) — INT
  • 1000_1059 (Field7) — INT
  • 1100_1159 (Field8) — INT
  • 1200_1259 (Field9) — INT
  • 1300_1359 (Field10) — INT
  • 1400_1459 (Field11) — INT
  • 1500_1559 (Field12) — INT
  • 1600_1659 (Field13) — INT
  • 1700_1759 (Field14) — INT
  • 1800_1859 (Field15) — INT
  • 1900_1959 (Field16) — INT
  • 2000_2059 (Field17) — INT
  • 2100_2159 (Field18) — INT
  • 2200_2259 (Field19) — INT
  • 2300_2359 (Field20) — INT
  • 0000_0059 (Field21) — INT

역 (Station)

  • station_id (PK) — INT — 기본 키 — NOT NULL
  • station_name (Field) — VARCHAR(32)
  • line (Field2) — INT

주소 및 전화번호 (Address_Contact)

  • station_id (PFK) — INT — 외래 키 → 역.station_id — NOT NULL
  • address (Field) — VARCHAR(255)
  • contact (Field2) — VARCHAR(20)

지하철 혼잡도 (Congestion)

  • congestion_id (PFK) — INT — 외래 키 → 혼잡도 기본정보.congestion_id — NOT NULL
  • con_0500_0529 (Field) — FLOAT
  • con_0530_0559 (Field2) — FLOAT
  • con_0600_0629 (Field3) — FLOAT
  • con_0630_0659 (Field4) — FLOAT
  • con_0700_0729 (Field5) — FLOAT
  • con_0730_0759 (Field6) — FLOAT
  • con_0800_0829 (Field7) — FLOAT
  • con_0830_0859 (Field8) — FLOAT
  • con_0900_0929 (Field9) — FLOAT
  • con_0930_0959 (Field10) — FLOAT
  • con_1000_1029 (Field11) — FLOAT
  • con_1030_1059 (Field12) — FLOAT
  • con_1100_1129 (Field13) — FLOAT
  • con_1130_1159 (Field14) — FLOAT
  • con_1200_1229 (Field15) — FLOAT
  • con_1230_1259 (Field16) — FLOAT
  • con_1300_1329 (Field17) — FLOAT
  • con_1330_1359 (Field18) — FLOAT
  • con_1400_1429 (Field19) — FLOAT
  • con_1430_1459 (Field20) — FLOAT
  • con_1500_1529 (Field21) — FLOAT
  • con_1530_1559 (Field22) — FLOAT
  • con_1600_1629 (Field23) — FLOAT
  • con_1630_1659 (Field24) — FLOAT
  • con_1700_1729 (Field25) — FLOAT
  • con_1730_1759 (Field26) — FLOAT
  • con_1800_1829 (Field27) — FLOAT
  • con_1830_1859 (Field28) — FLOAT
  • con_1900_1929 (Field29) — FLOAT
  • con_1930_1959 (Field30) — FLOAT
  • con_2000_2029 (Field31) — FLOAT
  • con_2030_2059 (Field32) — FLOAT
  • con_2100_2129 (Field33) — FLOAT
  • con_2130_2159 (Field34) — FLOAT
  • con_2200_2229 (Field35) — FLOAT
  • con_2230_2259 (Field36) — FLOAT
  • con_2300_2329 (Field37) — FLOAT
  • con_2330_2359 (Field38) — FLOAT
  • con_0000_0029 (Field39) — FLOAT

편의시설 (Facilities)

  • station_id (PFK) — INT — 외래 키 → 역.station_id — NOT NULL
  • cultural_space (Field) — CHAR(1)
  • wheelchair_lift (Field2) — CHAR(1)
  • meeting_place (Field3) — CHAR(1)
  • transfer_parking (Field4) — CHAR(1)
  • bicycle_parking (Field5) — CHAR(1)
  • elevator (Field6) — CHAR(1)
  • train_reservation (Field7) — CHAR(1)
  • unmanned_civil_service (Field8) — CHAR(1)
  • currency_exchange_kiosk (Field9) — CHAR(1)
  • nursing_room (Field10) — CHAR(1)

하차 인원 (Alighting_Count)

  • station_id (PFK) — INT — 외래 키 → 역.station_id — NOT NULL
  • 0400_0459 (Field) — INT
  • 0500_0559 (Field2) — INT
  • 0600_0659 (Field3) — INT
  • 0700_0759 (Field4) — INT
  • 0800_0859 (Field5) — INT
  • 0900_0959 (Field6) — INT
  • 1000_1059 (Field7) — INT
  • 1100_1159 (Field8) — INT
  • 1200_1259 (Field9) — INT
  • 1300_1359 (Field10) — INT
  • 1400_1459 (Field11) — INT
  • 1500_1559 (Field12) — INT
  • 1600_1659 (Field13) — INT
  • 1700_1759 (Field14) — INT
  • 1800_1859 (Field15) — INT
  • 1900_1959 (Field16) — INT
  • 2000_2059 (Field17) — INT
  • 2100_2159 (Field18) — INT
  • 2200_2259 (Field19) — INT
  • 2300_2359 (Field20) — INT
  • 0000_0059 (Field21) — INT

혼잡도 기본정보 (Congestion_Baseinfo)

  • congestion_id (PK) — INT — 기본 키 — NOT NULL
  • day_type (Field) — VARCHAR(10)
  • up_down_type (Field2) — VARCHAR(10)
  • station_id (FK) — INT — 외래 키 → 역.station_id — NOT NULL