illigal_physcial_erd
Tables (4)
CustomUser (Untitled4)
- id (Key) — integer — Primary key — NOT NULL
- username (uk) — varchar — Primary key — NOT NULL
- email (uk2) — varchar — Primary key — NOT NULL
- password (Field) — varchar
- last_login (Field2) — datetime
- first_name (Field5) — varchar
- last_name (Field6) — varchar
- is_staff (Field7) — boolean
- is_active (Field8) — boolean
- date_joined (field9) — datetime
- full_name (Field10) — varchar
- phone_number (Field11) — varchar
- car_number (Field12) — varchar
IllegalParkingRecord (Untitled2)
- id (pk) — integer — Primary key — NOT NULL
- id (pk2) — integer — Foreign key → TrafficCamera.id — NOT NULL
- camera_id (uk) — varchar — Foreign key → TrafficCamera.camera_id — NOT NULL
- timestamp (Field) — datetime
- district (Field2) — varchar
- record_num (Field3) — integer
ParkingLot (Untitled)
- id (pk) — integer — Primary key — NOT NULL
- name — varchar
- category (Field2) — varchar
- type (Field3) — varchar
- road_address (Field4) — varchar
- jibun_address (Field5) — varchar
- capacity (Field6) — integer
- operationg_days (Field7) — varchar
- wekday_start (Field) — varchar
- weekday_end (Field8) — varchar
- saturday_start (Field9) — varchar
- saturday_end (Field10) — varchar
- holiday_start (Field11) — varchar
- holiday_end (Field12) — varchar
- fee_type (Field13) — varchar
- base_time (Field14) — integer
- base_fee (Field15) — integer
- unit_fee (Field16) — integer
- unit_time (Field17) — integer
- daily_pass_time (Field18) — integer
- daily_pass_fee (Field19) — integer
- monthly_pass_fee (Field20) — integer
- phone_number (Field21) — varchar
- latitude (Field22) — real
- longitude (Field23) — real
- is_diabled_parking (Field24) — boolean
- pkpclid (Field25) — varchar
- number (Field26) — integer
TrafficCamera (Untitled3)
- id (pk) — integer — Primary key — NOT NULL
- camera_id (uk) — varchar — Primary key — NOT NULL
- address (Field2) — varchar
- latitude (Field3) — real
- longtitude (Field4) — real