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