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