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)