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)