취업도우미
테이블 (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)