CloudClub - 블로그만들기
테이블 (8)
ADM_WORK_SPACE_STND_LIST (근무공간기준내역)
- WORK_SPACE_STND_ID (Key) — BIGINT — 기본 키 — NOT NULL
- SECOM_TRMNL_TYPE_CODE (Field) — NVARCHAR(20)
- BLDG_CODE (Field2) — NVARCHAR(20)
- ENTRC_TYPE_CODE (Field3) — CHAR(1)
- SECOM_DEVICE_CODE (Field4) — NUMERIC(18,0)
- SECOM_DEVICE_NO (Field5) — NUMERIC(18,0)
- SECOM_ENTRC_NO (Field6) — NUMERIC(18,0)
- SECOM_LOWER_DEVICE_NO (Field7) — NUMERIC(18,0)
- SECOM_LOOP_NO (Field8) — NUMERIC(18,0)
- SECOM_TRMNL_NO (Field9) — NUMERIC(18,0)
- TRMNL_CNTNT (Field10) — NVARCHAR(200)
- TRMNL_NAME (Field11) — NVARCHAR(200)
- VALID_START_DATE (Field12) — DATE
- VALID_END_DATE (Field13) — DATE
- FIRST_CRT_EMP_NO (Field14) — NVARCHAR(6)
- FIRST_CRT_DTTM (Field15) — DATETIME
- LAST_UPD_EMP_NO (Field16) — NVARCHAR(6)
- LAST_UPD_DTTM (Field17) — DATETIME
Blog (블로그)
- BLOG_NO (블로그번호) — BIGINT(20) — 기본 키 — NOT NULL
- MEMBER_NO (회원 번호) — BIGINT(20) — 외래 키 → MEMBER.MEMBER_NO — NOT NULL
- CATEGORY_NO (Key) — BIGINT(20) — 외래 키 → CATEGORY.CATEGORY_NO — NOT NULL
- BLOG_TITLE (블로그명) — STRING
- BLOG_CONTENTS (블로그소개글) — STRING
- CREATED_AT (생성일) — DATETIME
- UPDATED_AT (수정일) — DATETIME
CATEGORY (카테고리)
- CATEGORY_NO (Key) — BIGINT(20) — 기본 키 — NOT NULL
- PARENT_CATEGORY_NO (Key2) — BIGINT(20) — 외래 키 → CATEGORY.CATEGORY_NO — NOT NULL
- CATEGORY_TYPE (Field2) — ENUM
- CATEGORY_NAME (Field) — STRING
- SORT_ORD (Field3) — BIGINT(20)
COMMENT (댓글)
- COMMENT_NO (댓글번호) — BIGINT(20) — 기본 키 — NOT NULL
- PARENT_COMMENT_NO (상위댓글번호) — BIGINT(20) — 외래 키 → COMMENT.COMMENT_NO — NOT NULL
- POST_NO (게시글번호) — BIGINT(20) — 외래 키 → POST.POST_NO — NOT NULL
- CREATED_MEMBER_NO (등록자) — BIGINT(20)
- COMMENT_CONTENT (댓글내용) — STRING
- UPDATED_AT (수정일) — DATETIME
- CREATED_AT (생성일) — DATETIME
- DEL_YN (삭제여부) — BOOLEAN
Copy Of ADM_WORK_SPACE_STND_LIST (CopyOf근무공간기준내역)
- WORK_SPACE_STND_ID (Key) — BIGINT — 기본 키 — NOT NULL
- SECOM_TRMNL_TYPE_CODE (Field) — NVACHAR(20)
- BLDG_CODE (Field2) — NVACHAR(20)
- ENTRC_TYPE_CODE (Field3) — CHAR(1)
- SECOM_DEVICE_CODE (Field4) — NUMERIC(18,0)
- SECOM_DEVICE_NO (Field5) — NUMERIC(18,0)
- SECOM_ENTRC_NO (Field6) — NUMERIC(18,0)
- SECOM_LOWER_DEVICE_NO (Field7)
MEMBER (회원)
- MEMBER_NO (회원 번호) — BIGINT(20) — 기본 키 — NOT NULL
- MEMBER_EMAIL (회원 이메일) — VARCHAR(255)
- MEMBER_PWD (비밀번호) — VARCHAR(255)
- MEMBER_STATUS (회원상태) — ENUM("ACTIVE","INACTIVE")
- CREATED_AT (생성일) — DATETIME
- UPDATED_AT (수정일) — DATETIME
MEMBER_SOCIALS (소셜로그인 정보)
- MEMBER_NO (회원 번호) — BIGINT(20) — 외래 키 → MEMBER.MEMBER_NO — NOT NULL
- PROVIDER (소셜타입) — ENUM("KAKAO","GOOGLE","SLACK")
- PROVIDER_ID (소셜ID) — VARCHAR(255)
- ACCESS_TOKEN (액세스토큰) — VARCHAR(255)
- REFRESH_TOKEN (리프레시토큰) — String
- EXPIRED_AT (만료일시) — DATETIME
- CREATED_AT (생성일) — DATETIME
- UPDATED_AT (수정일) — DATETIME
POST (게시글)
- POST_NO (게시글번호) — BIGINT(20) — 기본 키 — NOT NULL
- BLOG_NO (블로그번호) — BIGINT(20) — 외래 키 → Blog.BLOG_NO — NOT NULL
- POST_TITLE (Field) — STRING
- POST_CONTENT (게시글내용) — BLOB
- POST_FIX_YN (상단고정여부) — BOOLEAN
- VIEWS (조회수) — BIGINT(20)
- RECOMMAND_YN (추천가능여부) — BOOLEAN
- COMMENT_YN (댓글가능여부) — BOOLEAN
- POSTED_AT (작성일자) — DATETIME
- CREATED_AT (생성일) — DATETIME
- UPDATED_AT (수정일) — DATETIME