OWN_NOTE
테이블 (6)
ROLE (Untitled)
- USER_ID (PK&FK) — AUTO — 외래 키 → USER.USER_ID — NOT NULL
USER
- USER_ID (Key) — AUTO — 기본 키 — NOT NULL
- USER_MAIL (Field) — VARCHAR — NOT NULL
- USER_PW (Field2) — VARCHAR — NOT NULL
- USER_REGDATE (Field3) — TIMESTAMP — NOT NULL
- USER_ENABLED (Field4) — BOOLEAN — NOT NULL
- USER_NAME (Field5) — VARCHAR — NOT NULL
- USER_IMG (Field6) — IMAGE
개인 템플릿 (Untitled2)
- TPLT_ID (Key) — AUTO — 기본 키 — NOT NULL
- USER_ID (Key2) — AUTO — 외래 키 → USER.USER_ID — NOT NULL
- TPLT_TYPE (Field) — VARCHAR — NOT NULL
- TPLT_TITLE (Field2) — VARCHAR — NOT NULL
- TPLT_REGDATE (Field3) — TIMESTAMP — NOT NULL
- TPLT_MODIDATE (Field4) — TIMESTAMP
- TPLT_DOWN_CNT (Field5) — INT — NOT NULL
- TPLT_STATUS (Field6) — BOOLEAN — NOT NULL
- TPLT_DATA (Field7) — FILE — NOT NULL
공유 게시판 (SHARE)
- BOARD_ID (Key) — AUTO — 기본 키 — NOT NULL
- TPLT_ID (Key2) — AUTO — 외래 키 → 개인 템플릿.TPLT_ID — NOT NULL
- BOARD_TITLE (Field) — VARCHAR — NOT NULL
- BOARD_CONTENT (Field2) — VARCHAR
- BOARD_VIEW_CNT (Field4) — INT — NOT NULL
- BOARD_REGDATE (Field5) — TIMESTAMP — NOT NULL
- BOARD_MODIDATE (Field6) — TIMESTAMP
- BOARD_IMG (Field3) — IMAGE
로깅 데이터 (Untitled3)
- USER_ID (Key) — AUTO — 외래 키 → USER.USER_ID — NOT NULL
좋아요 (LIKE)
- LIKE_ID (Key) — AUTO — 기본 키 — NOT NULL
- BOARD_ID (Key3) — AUTO — 외래 키 → 공유 게시판.BOARD_ID — NOT NULL
- USER_ID (Key2) — AUTO — 외래 키 → USER.USER_ID — NOT NULL
- LIKE_REGDATE (Field) — TIMESTAMP — NOT NULL