cube

Tables (7)

board

  • boardSeq (시퀀스) — INT(15) — Primary key — NOT NULL
  • kategorieSeq (카테고리 시퀀스) — INT(11) — Foreign key → category.categorieSeq — NOT NULL
  • title (제목) — VARCHAR(30) — NOT NULL
  • content (내용 첫번째) — VARCHAR(5000)
  • writer (작성자) — VARCHAR(10) — NOT NULL
  • registration (등록일) — DATE — NOT NULL
  • tage (태그) — VARCHAR(100)
  • stake (좋아요) — INT(11)
  • work (힘내요) — INT(11)
  • views (조회수) — INT(11)
  • mseq (사용자 시퀀스) — int
  • Field

category (kategorie)

  • categorieSeq (시퀀스) — INT(11) — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(70)
  • state (상태) — INT(1)

comments

  • commentsSeq (시퀀스) — INT(11) — Primary key — NOT NULL
  • boardSeq (게시물 시퀀스) — INT(15) — Foreign key → board.boardSeq — NOT NULL
  • ordera (순서) — INT(11) — NOT NULL
  • content (내용) — VARCHAR(5000) — NOT NULL
  • parent (대댓글 확인) — INT(11) — NOT NULL
  • writer (작성자) — VARCHAR(50)
  • registration (등록인) — DATE — NOT NULL

contentimg

  • ciseq (시퀀스) — INT(15) — Primary key — NOT NULL
  • boardSeq (게시물 시퀀스) — INT(15) — Foreign key → board.boardSeq — NOT NULL
  • path (경로) — VARCHAR(80)
  • content (나머지 내용) — VARCHAR(1000)

member

  • mseq (유저아이디) — VARCHAR(15) — Primary key — NOT NULL
  • password (유저비밀번호) — VARCHAR(20) — NOT NULL
  • name (이름) — VARCHAR(15) — NOT NULL

tage

  • tageSeq (시퀀스) — INT(11) — Primary key — NOT NULL
  • boardSeq (게시물 시퀀스) — INT(15) — Foreign key → board.boardSeq — NOT NULL
  • tageName (태그명) — VARCHAR(50)
  • count (카운트) — INT(11)

views

  • memberId (유저아이디) — VARCHAR(15) — Foreign key → member.mseq — NOT NULL
  • boardSeq (게시물 시퀀스) — INT(15) — Foreign key → board.boardSeq — NOT NULL
  • date (날짜) — DATE — NOT NULL
  • stake (좋아요) — INT(11)
  • work (힘내요) — INT(11)
  • stakeChack (하루 좋아요 체크) — INT(11)
  • workChack (하루 힘내요 체크) — INT(11)