개인블로그
테이블 (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