취업도우미

테이블 (3)

j_Post (CopyOfUntitled)

  • postNum (Field) — number — 기본 키
  • userNum (Key1) — number — 외래 키 → j_User.userNum — NOT NULL
  • postTitle (Field2) — varchar(1000)
  • postContent (Field3) — varchar(7000)
  • postHit (Field4) — number
  • postRegdate (Field5) — date
  • postUpdatedate (Key2) — date — NOT NULL
  • boardNum (Key3) — number — NOT NULL

j_PostFile (Untitled2)

  • postFileNum (Key) — number — 기본 키 — NOT NULL
  • postNum (Field4) — number — 외래 키 → j_Post.postNum
  • isDeleted (Field3) — number
  • fileName (Field) — varchar(1000)
  • saveFileName (Field2) — varchar(2000)
  • filePathUrl (Field5) — varchar(1000)

j_User (Untitled)

  • userNum (Key1) — number — 기본 키 — NOT NULL
  • userId (Field2) — varchar(40)
  • userPwd — varchar(50) — NOT NULL
  • userNick (Key2) — varchar(50) — NOT NULL
  • userRole (Field) — varchar(50)