StarMoonBlog
Tables (5)
board_category
- bca_id — VARCHAR(255) — Primary key — NOT NULL — PK
- bca_key — varchar(255) — NOT NULL — category
- bca_value — varchar(255) — NOT NULL — 카테고리명
- bca_parent — varchar(255) — NOT NULL — 부모
- bca_order — int(11) — NOT NULL — 카테고리
board_post
- post_id — int(11) — Primary key — NOT NULL — PK
- post_num — int(11) — NOT NULL — 게시글
- post_title — varchar(255) — NOT NULL — 게시글
- post_content — mediumtext — 게시글
- post_datetime — datetime — NOT NULL — 게시물
- post_updated_datetime — datetime — NOT NULL — 최종
- post_comment_updated_datetime — datetime — 최근
- post_hit — int(11) — 조회수
- post_like — int(11) — 추천
- post_del — tinyint(4) — 게시물
- bca_id — VARCHAR(255) — Foreign key → board_category.bca_id — PK
- mem_id — int(11) — Foreign key → member.mem_id — PK
board_post_like
- like_id — int(11) — Primary key — NOT NULL — PK
- post_id — int(11) — Foreign key → board_post.post_id — NOT NULL — PK
- brd_id — int(11) — NOT NULL — 게시판
- target_type — tinyint(4) — NOT NULL — 0
- target_mem_id — int(11) — NOT NULL — 추천/비추를
- like_type — tinyint(4) — NOT NULL — 1
- like_datetime — datetime — 추천/비추
brd_post_comment
- cmt_id — int(11) — Primary key — NOT NULL — PK
- post_id — int(11) — Foreign key → board_post.post_id — NOT NULL — PK
- cmt_num — int(11) — NOT NULL — 댓글
- cmt_reply — varchar(20) — 답변
- cmt_secret — tinyint(4) — NOT NULL — 비밀글
- cmt_content — text — 댓글
- cmt_userid — varchar(100) — NOT NULL — 댓글
- cmt_username — varchar(100) — NOT NULL — 댓글
- cmt_datetime — datetime — 댓글
- cmt_updated_datetime — datetime — 댓글
- cmt_like — int(11) — NOT NULL — 추천
- cmt_del — tinyint(4) — NOT NULL — 댓글
member
- mem_id — int(11) — Primary key — NOT NULL — PK
- mem_userid — varchar(100) — NOT NULL — 회원
- mem_email — varchar(255) — NOT NULL — 회원
- mem_password — varchar(255) — NOT NULL — 회원
- mem_username — varchar(100) — NOT NULL — 회원
- mem_nickname — varchar(100) — NOT NULL — 회원
- mem_phone — varchar(255) — NOT NULL — 연락처
- mem_birthday — char(10) — NOT NULL — 생일
- mem_sex — tinyint(4) — NOT NULL — 성별
- mem_receive_email — tinyint(4) — NOT NULL — 이메일
- mem_register_datetime — datetime — 회원
- mem_lastlogin_datetime — datetime — 최종
- mem_lastlogin_ip — varchar(50) — NOT NULL — 최종
- mem_is_admin — tinyint(4) — NOT NULL — 최고관리자인지
- mem_profile_content — text — 자기소개
- mem_adminmemo — text — 관리자용
- mem_icon — varchar(255) — NOT NULL — 회원
- mem_photo — varchar(255) — NOT NULL — 회원