Arete
Tables (5)
MEMBER (사용자정보)
- id — varchar2(20) — Primary key — NOT NULL
- pwd — VARCHAR2(20) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- gender — CHAR(1)
- birthday — CHAR(6)
- email — VARCHAR2(30)
- zipcode — CHAR(5)
- address — VARCHAR2(100)
- detailAddress — VARCHAR2(50)
board (관리자전용 공지사항)
- id — varchar2(20) — Foreign key → MEMBER.id — NOT NULL
- num — number — NOT NULL
- name — varchar2(20) — NOT NULL
- subject — varchar2(50) — NOT NULL
- content — varchar2(4000) — NOT NULL
- regdate — date
- pass — varchar2(20) — NOT NULL
- count — number
- filename — varchar2(50)
- filesize — number
boardComment (공지사항 댓글)
- name — varchar2(20) — NOT NULL
- content — varchar2(2000) — NOT NULL
- regdate — date — NOT NULL
- id — varchar2(20) — Foreign key → freeBoard.id — NOT NULL
- id (id2) — varchar2(20) — Foreign key → board.id — NOT NULL
freeBoard (자유게시판 게시글 등록)
- id — varchar2(20) — Foreign key → MEMBER.id — NOT NULL
- num — number — NOT NULL
- name — varchar2(20) — NOT NULL
- subject — varchar2(50) — NOT NULL
- content — varchar2(4000) — NOT NULL
- pos — number
- ref — number
- depth — number
- regdate — date
- pass — varchar2(20) — NOT NULL
- ip — varchar2(100)
- count — number
- filename — varchar2(50)
- filesize — number
freeCommet (자유게시판 댓글)
- name — varchar2(20) — NOT NULL
- content — varchar2(2000) — NOT NULL
- regdate — date — NOT NULL
- id — varchar2(20) — Foreign key → freeBoard.id — NOT NULL