blog

테이블 (6)

게시글테이블 (POSTS)

  • IDX (PK) — NUMBER — 기본 키 — NOT NULL
  • USER_IDX (FK) — NUMBER — 외래 키 → 회원테이블.IDX — NOT NULL
  • TITLE (Field) — VARCHAR2
  • CONTENT (Field2) — CLOB
  • NICKNAME (Field3) — VARCHAR2
  • CREATED_DATE (Field4) — TIMESTAMP
  • BISIBILITY (Field5) — VARCHAR2
  • VIEWS (Field6) — NUMBER
  • LIKES (Field7) — NUMBER
  • Field8

댓글 테이블 (BlogComment)

  • COMMENTIDX (PK) — NUMBER — 기본 키 — NOT NULL
  • POSTS_IDX' (FK) — NUMBER — 외래 키 → 게시글테이블.IDX — NOT NULL
  • USER_IDX (FK2) — NUMBER — 외래 키 → 게시글테이블.USER_IDX — NOT NULL
  • NICKNAME (Field) — VARCHAR2
  • CONTENT (Field2) — CLOB
  • CREATED_DATE (Field3) — TIMESTAMP

방문자 테이블 (Visitor)

  • ID (PK) — NUMBER — 기본 키 — NOT NULL
  • VIEWER_ID (FK) — NUMBER — 기본 키 — NOT NULL
  • VISITED_USER_ID (FK2) — NUMBER — 외래 키 → 회원테이블.IDX — NOT NULL
  • VISITED_DATE (Field) — SYSDATE

블로그설정 테이블 (BlogSettings)

  • USER_IDX (PK) — NUMBER — 외래 키 → 회원테이블.IDX — NOT NULL
  • BLOGNICKNAME (Field) — VARCHAR2
  • BLOG_IMAGE (Field2) — VARCHAR2
  • BLOG_MASSAGE (Field3) — VARCHAR2
  • BLOG_TITLE (Field4) — VARCHAR2
  • LAYOUT (Field5) — NUMBER

첨부파일 테이블 (Attachments)

  • ATTACHMENT_ID (PK) — NUMBER — 기본 키 — NOT NULL
  • POSTS_IDX (FK) — NUMBER — 외래 키 → 게시글테이블.IDX — NOT NULL
  • ATTACHMENT_URL (Field) — VARCHAR2
  • Field2ATTACHMENT_TYPE (Field2) — VARCHAR2
  • UPLOADED_DATE (Field3) — DATE
  • FILENAME (Field4) — VARCHAR2

회원테이블 (USERS)

  • IDX (PK) — NUMBER — 기본 키 — NOT NULL
  • ID (Field) — VARCHAR2
  • PWD (Field2) — VARCHAR2
  • NAME (Field3) — VARCHAR2
  • AGE (Field4) — NUMBER
  • BIRTHDAY (Field5) — VARCHAR2
  • NICKNAME (Field6) — VARCHAR2
  • EMAIL (Field7) — VARCHAR2
  • ADDRESS (Field8) — VARCHAR2
  • TODAY (Field9) — DATE
  • POSTAL_CODE (Field10) — VARCHAR2
  • DETAIL_ADDRESS (Field11)