오늘의일기

테이블 (3)

일기테이블 (SYS_STORY_CD)

  • Key (SEQ) — INT — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR(100)
  • Field (CONTENT) — VARCHAR(3000)
  • Field (TYPE) — CHAR(1)
  • Field (VIEW) — INT
  • Field (USER_ID) — VARCHAR(50)
  • Field (CREATE_DATE) — DATETIME
  • Field (UPDATE_DATE) — DATETIME

댓글테이블 (SYS_STORY_COMMENT_CD)

  • Key (SEQ) — INT — 기본 키 — NOT NULL
  • Field (STORY_SEQ) — INT
  • Field (CONTENT) — VARCHAR(3000)
  • Field (TYPE) — CHAR(1)
  • Field (USER_ID) — VARCHAR(50)
  • Field (CREATE_DATE) — DATETIME
  • Field (UPDATE_DATE) — DATETIME

신고테이블 (SYS_REPORT_CD)

  • Key (SEQ) — INT — 기본 키 — NOT NULL
  • Field (REPORT_SEQ) — INT
  • Field (TYPE) — CHAR(1)
  • Field (USER_ID) — VARCHAR(50)
  • Field (CREATE_DATE) — DATETIME