pr2
Tables (12)
User (Untitled)
- userid (유저아이디) — varchar(50) — Primary key — NOT NULL
- userpw (비밀번호) — varchar(100)
- username (이름) — varchar(100)
- useremail (이메일) — varchar(100)
- userphone (전화번호) — varchar(50)
- usergender (성별) — char(3)
- zipcode (우편번호) — varchar(30)
- useraddr (주소) — varchar(1000)
- addrdetail (상세주소) — varchar(2000)
- addretc (참고항목) — varchar(300)
board (Untitled3)
- boardnum (게시글번호) — bigint — Primary key — NOT NULL
- boardtitle (제목) — varchar(300)
- boardcontent (내용) — varchar(1000)
- userid (아이디) — varchar(50)
- boardregdate (날짜) — varchar(50)
- boardreadcnt (조회수) — bigint
- tag (태그) — varchar(300)
- titleImage (대표이미지) — varchar(300)
board_like (CopyOfUntitled92)
- boardnum (게시글번호) — bigint
- userid (아이디) — varchar(50)
board_photo (Untitled5)
- boardnum (게시글번호) — bigint
- systemname (Field2) — varchar(300)
board_report (Untitled9)
- boardnum (게시글번호) — bigint
- userid (신고한 유저) — varchar(50)
bookmark (Untitled2)
- bmNum (즐격찾기번호) — bigint — Primary key — NOT NULL
- userid (유저아이디) — varchar(50)
- contentid (축제고유번호) — varchar(50)
note (Untitled8)
- notenum (쪽지번호) — bigint — Primary key — NOT NULL
- senduser (보낸사람) — varchar(50)
- receiveuser (받는사람) — varchar(50)
- title (제목) — varchar(300)
- contents (내용) — varchar(1000)
- regdate (날짜) — varchar(50)
- readcnt (조회수) — bigint
notice (Untitled6)
- noticenum (공지번호) — bigint — Primary key — NOT NULL
- noticetitle (제목) — varchar(300)
- noticecontent (내용) — varchar(1000)
- userid (관리자) — varchar(50)
- noticeregdate (등록날짜) — varchar(50)
notice_file (Untitled7)
- noticenum (공지번호) — bigint
- orgname (원래이름) — varchar(300)
- systemname (시스템이름) — varchar(300)
reply (Untitled4)
- replynum (댓글번호) — bigint — Primary key — NOT NULL
- replycontent (내용) — varchar(300)
- userid (아이디) — varchar(50)
- boardnum (게시글번호) — bigint
- replyregdate (등록날짜) — varchar(50)
reply_report (CopyOfUntitled9)
- replynum (게시글번호) — bigint
- userid (신고한 유저) — varchar(50)
user_photo (Untitled10)
- userid (유저아이디) — varchar(50)
- systemname (사진이름) — varchar(300)