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