1

Tables (7)

boardTABLE (-)

  • idx (primarykey) — number — Primary key — NOT NULL
  • name (작성자이름) — varchar(20)
  • subject (제목)
  • contents (내용) — varchar(2000)
  • regdate (작성일자) — date
  • readcnt (조회수) — number
  • userid (FK) — varchar(20) — Foreign key → memberTABLE.userid

board_comments_TABLE (Untitled3)

  • idx (primarykey) — number — Primary key — NOT NULL
  • NAME (작성자이름) — varchar(50)
  • parent (FK) — number — Foreign key → boardTABLE.idx — NOT NULL
  • comments (댓글내용) — varchar(2000)
  • regdate (작성일자) — date
  • userid (uique) — varchar(20) — Foreign key → memberTABLE.userid

galleryTABLE (Untitled)

  • idx (primarykey) — number — Primary key — NOT NULL
  • name (작성자이름) — varchar(20)
  • subject (제목)
  • contents (내용) — varchar(2000)
  • regdate (작성일자) — date
  • filename (첨부파일명) — varchar(255(
  • readcnt (조회수) — number — NOT NULL
  • userid (FK) — varchar(20) — Foreign key → memberTABLE.userid

memberTABLE (Untitled2)

  • userid (uique) — varchar(20) — Primary key
  • idx (primarykey) — number — Primary key — NOT NULL
  • name (가입자성명) — varchar(20)
  • passwd (비밀번호) — varchar(200)
  • grade (회원등급) — char
  • email (이메일) — varchar(100)
  • first_time (가입일) — date
  • last_time (마지막접속일) — date

noticeTABLE (--)

  • idx (primarykey) — number — Primary key — NOT NULL
  • name (작성자이름) — varchar(20)
  • subject (제목)
  • contents (내용) — varchar(2000)
  • regdate (작성일자) — date
  • readcnt (조회수) — number
  • filename (첨부파일명) — varchar(255(
  • userid (FK) — varchar(20) — Foreign key → memberTABLE.userid

pdsTABLE (---)

  • idx (primarykey) — number — Primary key — NOT NULL
  • name (작성자이름) — varchar(20)
  • subject (제목)
  • contents (내용) — varchar(2000)
  • regdate (작성일자) — date
  • readcnt (조회수) — number
  • filename (첨부파일명) — varchar(255(
  • userid (FK) — varchar(20) — Foreign key → memberTABLE.userid

qaTABLE (1)

  • idx (primarykey) — number — Primary key — NOT NULL
  • name (작성자이름) — varchar(20)
  • subject (제목)
  • contents (내용) — varchar(2000)
  • regdate (작성일자) — date
  • readcnt (조회수) — number
  • filename (첨부파일명) — varchar(255(
  • replycehck (답변여부확인) — char(1)
  • reply (답변) — varchar(2000)
  • tel (전화번호) — varchar(30)
  • userid (FK) — varchar(20) — Foreign key → memberTABLE.userid