SelfBlog
테이블 (8)
Untitled (like)
- Key (like_id) — number — 기본 키 — NOT NULL
- Field (board_id) — number not null
- Field (member_id) — varchar2(255) not null
- Field
Untitled (Push)
- Key (push_id) — number — 기본 키 — NOT NULL
- Field (member_id) — number not null
- Field (push_content) — varchar2(1000) not null
- Field (push_is_seen) — varchar2(1) default "N"
- Field (push_date) — date default sysdate
- Field
Untitled (Team)
- Key (team_id) — number — 기본 키 — NOT NULL
- Field (team_name) — varchar2(255) not null
- Field (team_master) — varchar2(255) not null
- Field (team_members) — varchar2(255) null
- Field
Untitled (blog)
- Key (blog_adress) — varchar2(255) — 기본 키 — NOT NULL
- Field (blog_writer) — varchar2(255)
- Field (blog_name) — varchar2(255)
- Field (blog_explanation) — varchar2(500)
- Field (blog_is_team) — varchar2(1) default "N"
- Field (blog_is_del) — varchar2(1) default "N"
- Field (blog_background_img) — varchar2(255) default "default.jpg"
- Field (blog_main_img) — varchar2(255) default "default.jpg'
- Field (blog_is_private) — varchar2(1) default "N"
- Field
게시물 (Board)
- 아이디 (board_id) — number — 기본 키 — NOT NULL
- 카테고리 아이디 (category_id) — number
- 제목 (board_title) — varchar2(255) not null
- 본문 (board_content) — varchar2(5000) default "내용이 없습니다."
- 작성자 (board_writer) — varchar2(255) not null
- 작성일 (board_write_date) — date default sysdate
- 수정일 (board_modify_date) — date null
- 조회수 (hit) — number default 0
- 게시물 삭제 플래그 (board_is_del) — varchar2(1) default "N"
- Field (board_main_img) — varchar2(255) null
- Field (board_is_private) — varchar2(1) default "N"
- Field (board_teg) — varchar2(50) null
댓글 (Reply)
- Key (reply_id) — number — 기본 키 — NOT NULL
- Field (board_id) — number
- Field (reply_content) — varchar2(1000)
- Field (reply_writer) — varchar2(255) not null
- Field (reply_write_date) — date default sysdate
- Field (reply_modified_date) — date null
- Field (reply_parent_id) — number default 0
- Field (reply_depth) — number default 0
- Field (reply_order) — number default 0
- Field (reply_like) — number default 0
- Field
카테고리 (Category)
- 카테고리 아이디 (category_id) — number auto increases — 기본 키 — NOT NULL
- 카테고리 이름 (category_name) — varchar2(255) not null
- 카테고리 삭제 플래그 (category_is_del) — varchar2(1) default "N"
- Field (blog_id) — number
- Field
회원 (Member)
- 아이디 (member_id) — varchar2(255) — 기본 키 — NOT NULL
- 비밀번호(암호화) (member_pwd) — varchar2(255) not null
- 이름 (member_name) — varchar2(255) not null
- 생일 (member_birth) — date null
- 전화번호 (member_tel) — varchar2(255) null
- 이메일 (member_email) — varchar2(255) not null
- 프로필 사진 (member_img) — varchar2(255) default 'default.jpg'
- 회원 삭제 플래그 (member_is_del) — varchar2(1) default "N"
- Field (member_status_message) — varchar2(300)
- Field