개인블로그

테이블 (7)

TBL_CATEGORY (CopyOftag2)

  • category_id (id) — bigint — 기본 키 — NOT NULL
  • name (description) — varchar(50) — NOT NULL
  • sort (Field2) — int — NOT NULL
  • reg_user (reg_date) — varchar(50) — NOT NULL
  • reg_date (mod_date) — datetime2 — NOT NULL
  • mod_user (use_yn) — varchar(50)
  • mod_date (Field) — datetime2

TBL_MEMBER (tag)

  • user_id (id) — bigint — 기본 키 — NOT NULL
  • role_id (id2) — bigint — 외래 키 → TBL_ROLE.role_id — NOT NULL
  • name (description) — varchar(50) — NOT NULL
  • password (reg_date) — varchar(50) — NOT NULL
  • reg_user (mod_date) — varchar(50) — NOT NULL
  • reg_date (use_yn) — datetime2 — NOT NULL
  • mod_date (Field) — datetime2

TBL_POST (CopyOfCopyOftag2)

  • post_id (id) — bigint — 기본 키 — NOT NULL
  • category_id (id2) — bigint — 외래 키 → TBL_CATEGORY.category_id — NOT NULL
  • title (reg_date) — varchar(50) — NOT NULL
  • thumbnail (mod_date) — varchar(400)
  • main_sort (use_yn) — smallint — NOT NULL
  • use_yn (Field) — char(1) — NOT NULL
  • reg_user (Field2) — varchar(50) — NOT NULL
  • reg_date (Field3) — datetime2 — NOT NULL

TBL_POST_CONTENT (CopyOfCopyOftag22)

  • content_id (id) — bigint — 기본 키 — NOT NULL
  • post_id (id2) — bigint — 외래 키 → TBL_POST.post_id — NOT NULL
  • state_id (id3) — smallint — 외래 키 → TBL_POST_CONTENT_STATE.state_id — NOT NULL
  • contents (description) — varchar(0) — NOT NULL
  • reg_date — datetime2 — NOT NULL

TBL_POST_CONTENT_STATE (CopyOfCopyOfCopyOftag22)

  • state_id (id) — smallint — 기본 키 — NOT NULL
  • reg_date — datetime2 — NOT NULL

TBL_POST_VIEW (Untitled)

  • view_id (Key) — bigint — 기본 키 — NOT NULL
  • post_id (id) — bigint — 외래 키 → TBL_POST.post_id — NOT NULL
  • view (Field) — bigint — NOT NULL
  • visite (Field3) — bigint — NOT NULL
  • reg_date (Field2) — datetime2

TBL_ROLE (CopyOftag)

  • role_id (id) — bigint — 기본 키 — NOT NULL
  • action (description) — varchar(50) — NOT NULL
  • use_yn (reg_date) — char(1) — NOT NULL