23
Tables (9)
ENTRY_EXIT_LOG
- LOG_ID — NUMBER(10)
- PLATE_NUM — VARCHAR2(15) — NOT NULL
- LOT_ID — NUMBER(8) — NOT NULL
- IN_TIME — DATE
- OUT_TIME — DATE
- LPR_IMG — VARCHAR2(200)
IOT_SENSOR
- SENSOR_ID — VARCHAR2(20)
- SPACE_ID — NUMBER(8) — NOT NULL
- TYPE — VARCHAR2(20)
- BATTERY — NUMBER(3)
- STATUS — VARCHAR2(10)
- LAST_UPDATE — DATE
MAINT_LOG
- MAINT_ID — NUMBER(10)
- SENSOR_ID — VARCHAR2(20)
- ISSUE_DATE — DATE
- CAUSE — VARCHAR2(200)
- FIX_DATE — DATE
- WORKER — VARCHAR2(20)
PARKING_LOT
- LOT_ID — NUMBER(8)
- NAME — VARCHAR2(50) — NOT NULL
- ADDRESS — VARCHAR2(100) — NOT NULL
- BASE_FEE — NUMBER(8)
- OPER_START — VARCHAR2(5)
- OPER_END — VARCHAR2(5)
PARKING_SPACE
- SPACE_ID — NUMBER(8)
- LOT_ID — NUMBER(8) — NOT NULL
- FLOOR — VARCHAR2(10) — NOT NULL
- ZONE — VARCHAR2(10) — NOT NULL
- STATUS — CHAR(1)
PAYMENT
- PAY_ID — NUMBER(10)
- RES_ID — NUMBER(10)
- LOG_ID — NUMBER(10)
- AMOUNT — NUMBER(10) — NOT NULL
- METHOD — VARCHAR2(20)
- PAY_DATE — DATE
- STATUS — VARCHAR2(10)
RESERVATION
- RES_ID — NUMBER(10)
- USER_ID — VARCHAR2(20) — NOT NULL
- SPACE_ID — NUMBER(8) — NOT NULL
- PLATE_NUM — VARCHAR2(15) — NOT NULL
- START_TIME — DATE — NOT NULL
- END_TIME — DATE — NOT NULL
- STATUS — VARCHAR2(10)
- CREATED_AT — DATE
SUBSCRIPTION
- SUB_ID — NUMBER(10)
- USER_ID — VARCHAR2(20) — NOT NULL
- START_DATE — DATE
- END_DATE — DATE — NOT NULL
- AUTO_RENEW — CHAR(1)
VEHICLE
- PLATE_NUM — VARCHAR2(15)
- USER_ID — VARCHAR2(20) — NOT NULL
- CAR_TYPE — VARCHAR2(20)
- COLOR — VARCHAR2(20)
- REG_DATE — DATE