parkingERD

Tables (3)

TB_PARKING_DETAIL (주차장 세부 정보)

  • SERIAL_ID (Key) — VARCHAR(45) — Primary key — NOT NULL
  • ID (Key2) — VARCHAR(45) — Foreign key → TB_PARKING_MAIN.ID — NOT NULL
  • TOTALSPOTS (Field) — VARCHAR(45)
  • ENABLE (Field2) — BOOLEAN

TB_PARKING_LOG (주차장 현황 및 로그)

  • TIME (Key) — DATETIME — Primary key — NOT NULL
  • SERIAL_ID (Key3) — VARCHAR(45) — Foreign key → TB_PARKING_DETAIL.SERIAL_ID — NOT NULL
  • ENABLE (Field1) — INTEGER(10)
  • TOTAL (Field2) — INTEGER(10)
  • ENABLELIST (Field3) — VARCHAR(45)
  • OCUPIEDLIST (Field4) — VARCHAR(45)

TB_PARKING_MAIN (서비스중인 주차장 리스트)

  • ID (Key) — VARCHAR(45) — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(45)
  • LATUTUDE (Field2) — VARCHAR(45)
  • LONGITUDE (Field3) — VARCHAR(45)
  • ADMIN (Field4) — VARCHAR(45)
  • OWNER (Field5) — VARCHAR(45)