U&I Company Prj

Tables (3)

TB_dev (Untitled)

  • userNo (Key) — number — Foreign key → TB_user.userNo — NOT NULL
  • jobType (Field3) — varchar2(20)

TB_notice (Untitled3)

  • postNo (Key) — number — Primary key — NOT NULL
  • userNo (Key2) — number — Foreign key → TB_user.userNo — NOT NULL
  • title (Field) — varchar2(100)
  • content (Field2) — varchar2(500)
  • writer (Field3) — varchar2(30)
  • cDate (Field4) — date
  • eDate (Field5) — number
  • views (Field6) — number

TB_user (Untitled2)

  • userNo (Key) — number — Primary key — NOT NULL
  • id (Filed) — varchar2(30)
  • name (Field2) — varchar2(50)
  • email (Field3) — varchar2(100)
  • auth (Field) — varchar2(20)
  • password (Field4) — varchar2(40)