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