TeamHijacking_SEE
Tables (7)
IOT_service (IOT 연동 여부 및 관리)
- iot_id (iot.,.와.,,. 어떤 기기인지.,., 고유 번호? 인지....,. ?...) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
TimeTable
- Key (route_id) — NOT NULL — Primary key — NOT NULL
- Field (Station_Name) — NOT NULL — Primary key
- Field (Arrival_time) — NOT NULL — Primary key
- Field (Day_Type) — NOT NULL — Primary key
- Field (Train_Id) — NOT NULL — Primary key
- Field (Region) — NOT NULL
- Field (Direction) — NOT NULL
Untitled (station)
- Key (station_id) — NOT NULL — Primary key — NOT NULL
- Field (statn_nm)
- Field (api_id) — NOT NULL
Untitled (time_table)
- Key (arrival_time) — NOT NULL — Primary key — NOT NULL
- Field (day_type) — NOT NULL — Primary key
- Field (station_name) — NOT NULL — Primary key
- Field (train_id) — NOT NULL — Primary key
- Field (route_id) — NOT NULL — Primary key
- Field (direction)
- Field (region)
User (회원)
- id (user_id) — NOT NULL — Primary key — NOT NULL
- login_id (로그인 아이디) — NOT NULL
- password (비밀번호) — NOT NULL
- name (이름) — NOT NULL
- create_at (생성일시) — NOT NULL
- update_at (수정일시) — NOT NULL
transportRoot (교통 안내 경로)
- transportRootKey (교통 안내 경로 저장용 고유 키) — NOT NULL — Primary key — NOT NULL
- id (user_id2) — NOT NULL — Foreign key → transportRootList.id — NOT NULL
- departure_root (출발지) — NOT NULL
- destination_root (도착지) — NOT NULL
- start_root (언제 처음 갔는지) — NOT NULL
- last_root (마지막에 언제 갔는지) — NOT NULL
- root_count (몇 번 갔는지) — NOT NULL
- favourite_root (즐겨찾기 했는지) — NOT NULL — TINYINT(1)은 boolean을 나타낸다고 함
- saved_root (저장 했는지) — NOT NULL
- startLat (출발지 위도) — NOT NULL
- startLng (출발치 경도) — NOT NULL
- endLat (도착지 위도) — NOT NULL
- endLng (도착지 경도) — NOT NULL
- route_id (경로 안내)
transportRootList (교통 안내 경로 리스트)
- transportRootList_id (교통 안내 경로 리스트 키) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- rootListCount (몇 개 저장되어있는지...) — NOT NULL