project

Tables (5)

Carlist

  • idx — int — Primary key — NOT NULL
  • carnum — varchar2(100)
  • carmodel — varchar2(150)
  • cartype — varchar2(100)

Cctvlist (cctvlist)

  • idx — int — Primary key — NOT NULL
  • cctvnum — varchar2(100)
  • ids — varchar2(100)
  • cctvloca — varchar2(100)

Noticelist (Notice)

  • idx — int — Primary key — NOT NULL
  • titles — varchar2(200)
  • bodys — text
  • dates — date

Recordlist (Record)

  • idx — int — Primary key — NOT NULL
  • carnum — varchar2(40)
  • ids — varchar2(60)
  • imgs — varchar2(100)
  • dates — date
  • cctvnum — varchar2(100)

Userlist

  • idx — int — Primary key — NOT NULL
  • ids — varchar2(100)
  • pwd — varchar2(100) — NOT NULL
  • first-name (fname) — varchar2(100)
  • email — varchar2(100)
  • last-name (lname) — varchar2(100)