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