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