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)