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