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