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