ERD_Subway

테이블 (9)

공중화장실 (Public_Restrooms)

  • restroom_id (PK) — NUMBER(3) — 기본 키 — NOT NULL
  • position (Field) — VARCHAR2(255)
  • ground_type (Field2) — VARCHAR2(10)
  • gate_type (Field3) — VARCHAR2(10)
  • station_id (FK) — NUMBER(4) — 외래 키 → 역.station_id — NOT NULL

물품보관함 (Lockers)

  • locker_id (PK) — NUMBER(3) — 기본 키 — NOT NULL
  • locker_name (Field) — VARCHAR2(50)
  • position (Field2) — VARCHAR2(255)
  • small_count (Field3) — NUMBER(3)
  • medium_count (Field4) — NUMBER(3)
  • large_count (Field5) — NUMBER(3)
  • station_id (FK) — NUMBER(4) — 외래 키 → 역.station_id — NOT NULL

승차 인원 (Boarding_Count)

  • station_id (PFK) — NUMBER(4) — 외래 키 → 역.station_id — NOT NULL
  • b_0400 (Field) — NUMBER(7)
  • b_0500 (Field2) — NUMBER(7)
  • b_0600 (Field3) — NUMBER(7)
  • b_0700 (Field4) — NUMBER(7)
  • b_0800 (Field5) — NUMBER(7)
  • b_0900 (Field6) — NUMBER(7)
  • b_1000 (Field7) — NUMBER(7)
  • b_1100 (Field8) — NUMBER(7)
  • b_1200 (Field9) — NUMBER(7)
  • b_1300 (Field10) — NUMBER(7)
  • b_1400 (Field11) — NUMBER(7)
  • b_1500 (Field12) — NUMBER(7)
  • b_1600 (Field13) — NUMBER(7)
  • b_1700 (Field14) — NUMBER(7)
  • b_1800 (Field15) — NUMBER(7)
  • b_1900 (Field16) — NUMBER(7)
  • b_2000 (Field17) — NUMBER(7)
  • b_2100 (Field18) — NUMBER(7)
  • b_2200 (Field19) — NUMBER(7)
  • b_2300 (Field20) — NUMBER(7)
  • b_0000 (Field21) — NUMBER(7)
  • b_0100 (Field22) — NUMBER(7)
  • b_0200 (Field23) — NUMBER(7)
  • b_0300 (Field24) — NUMBER(7)

역 (Station)

  • station_id (PK) — NUMBER(4) — 기본 키 — NOT NULL
  • station_name (Field) — VARCHAR2(32)
  • line (Field2) — NUMBER(1)

주소 및 전화번호 (Address_Contact)

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

지하철 혼잡도 (Congestion)

  • congestion_id (PFK) — NUMBER(4) — 외래 키 → 혼잡도 기본정보.congestion_id — NOT NULL
  • c_0500 (Field) — NUMBER(4,1)
  • c_0530 (Field2) — NUMBER(4,1)
  • c_0600 (Field3) — NUMBER(4,1)
  • c_0630 (Field4) — NUMBER(4,1)
  • c_0700 (Field5) — NUMBER(4,1)
  • c_0730 (Field6) — NUMBER(4,1)
  • c_0800 (Field7) — NUMBER(4,1)
  • c_0830 (Field8) — NUMBER(4,1)
  • c_0900 (Field9) — NUMBER(4,1)
  • c_0930 (Field10) — NUMBER(4,1)
  • c_1000 (Field11) — NUMBER(4,1)
  • c_1030 (Field12) — NUMBER(4,1)
  • c_1100 (Field13) — NUMBER(4,1)
  • c_1130 (Field14) — NUMBER(4,1)
  • c_1200 (Field15) — NUMBER(4,1)
  • c_1230 (Field16) — NUMBER(4,1)
  • c_1300 (Field17) — NUMBER(4,1)
  • c_1330 (Field18) — NUMBER(4,1)
  • c_1400 (Field19) — NUMBER(4,1)
  • c_1430 (Field20) — NUMBER(4,1)
  • c_1500 (Field21) — NUMBER(4,1)
  • c_1530 (Field22) — NUMBER(4,1)
  • c_1600 (Field23) — NUMBER(4,1)
  • c_1630 (Field24) — NUMBER(4,1)
  • c_1700 (Field25) — NUMBER(4,1)
  • c_1730 (Field26) — NUMBER(4,1)
  • c_1800 (Field27) — NUMBER(4,1)
  • c_1830 (Field28) — NUMBER(4,1)
  • c_1900 (Field29) — NUMBER(4,1)
  • c_1930 (Field30) — NUMBER(4,1)
  • c_2000 (Field31) — NUMBER(4,1)
  • c_2030 (Field32) — NUMBER(4,1)
  • c_2100 (Field33) — NUMBER(4,1)
  • c_2130 (Field34) — NUMBER(4,1)
  • c_2200 (Field35) — NUMBER(4,1)
  • c_2230 (Field36) — NUMBER(4,1)
  • c_2300 (Field37) — NUMBER(4,1)
  • c_2330 (Field38) — NUMBER(4,1)
  • c_0000 (Field39) — NUMBER(4,1)

편의시설 (Facilities)

  • station_id (PFK) — NUMBER(4) — 외래 키 → 역.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) — NUMBER(4) — 외래 키 → 역.station_id — NOT NULL
  • a_0400 (Field) — NUMBER(7)
  • a_0500 (Field2) — NUMBER(7)
  • a_0600 (Field3) — NUMBER(7)
  • a_0700 (Field4) — NUMBER(7)
  • a_0800 (Field5) — NUMBER(7)
  • a_0900 (Field6) — NUMBER(7)
  • a_1000 (Field7) — NUMBER(7)
  • a_1100 (Field8) — NUMBER(7)
  • a_1200 (Field9) — NUMBER(7)
  • a_1300 (Field10) — NUMBER(7)
  • a_1400 (Field11) — NUMBER(7)
  • a_1500 (Field12) — NUMBER(7)
  • a_1600 (Field13) — NUMBER(7)
  • a_1700 (Field14) — NUMBER(7)
  • a_1800 (Field15) — NUMBER(7)
  • a_1900 (Field16) — NUMBER(7)
  • a_2000 (Field17) — NUMBER(7)
  • a_2100 (Field18) — NUMBER(7)
  • a_2200 (Field19) — NUMBER(7)
  • a_2300 (Field20) — NUMBER(7)
  • a_0000 (Field21) — NUMBER(7)
  • a_0100 (Field22) — NUMBER(7)
  • a_0200 (Field23) — NUMBER(7)
  • a_0300 (Field24) — NUMBER(7)

혼잡도 기본정보 (Congestion_Baseinfo)

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