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)