관제그룹정보관리사이트

테이블 (10)

BookMarks (즐겨찾기)

  • book_id (PK) — int — 기본 키 — NOT NULL
  • user_id (FK1) — char(20) — 외래 키 → Users.user_id — NOT NULL
  • content_id (FK3) — varchar(32) UUID — 외래 키 → Contents.content_id — NOT NULL
  • book_mark_name (Field3) — varchar(32) — NOT NULL

Comments (댓글)

  • comment_no (PK) — int — 기본 키 — NOT NULL
  • user_id (FK1) — char(20) — 외래 키 → Users.user_id — NOT NULL
  • content_id (FK2) — varchar(32) UUID — 외래 키 → Contents.content_id — NOT NULL
  • comment_desc (Field) — varchar(255)
  • create_time (Field2) — datetime

ContentTypes (컨텐츠 유형)

  • content_type_code (PK) — char(12) — 기본 키 — NOT NULL
  • content_type_desc (Field) — varchar(32) — NOT NULL
  • use_yn (Field2) — char(1)

Contents (컨텐츠)

  • content_id (PK) — varchar(32) UUID — 기본 키 — NOT NULL
  • project_id (PK2) — int — 외래 키 → Projects.project_id — NOT NULL
  • content_type_code (PK3) — char(12) — 외래 키 → ContentTypes.content_type_code — NOT NULL
  • content_title (Field) — varchar(255) — NOT NULL
  • content_details (Field2) — varchar(max)
  • create_time (Field3) — datetime
  • creator (Field4) — char(20)
  • modity_time (Field5) — datetime
  • modifier (Field6) — char(20)
  • access_count (Field7) — int
  • hit_count (Field8) — int
  • use_yn (Field9) — char(1)
  • del_yn (Field10) — char(1)

FileTypes (파일타입)

  • file_type (PK) — int — 기본 키 — NOT NULL
  • file_id (PK2) — int — 외래 키 → Files.file_id — NOT NULL
  • file_type_name (Field) — char(4) — NOT NULL
  • use_yn (Field2) — char(1)

Files (파일)

  • file_id (PK) — int — 기본 키 — NOT NULL
  • content_id (PK2) — varchar(32) UUID — 외래 키 → Contents.content_id — NOT NULL
  • file_path (Field) — varchar(255) — NOT NULL
  • file_name (Field2) — varchar(100)

Projects (프로젝트)

  • project_id (PK) — int — 기본 키 — NOT NULL
  • project_name (Field) — varchar(255) — NOT NULL
  • project_image_url (Field2) — varchar(255) — NOT NULL
  • create_time (Field3) — datetime — NOT NULL
  • creator (Field4) — char(20) — NOT NULL
  • modify_time (Field5) — datetime — NOT NULL
  • modifier (Field6) — char(20) — NOT NULL
  • use_yn (Field7) — char(1) — NOT NULL
  • del_yn (Field8) — char(1) — NOT NULL

RoleContentsIntf (권한인터페이스)

  • role_code (PK) — char(15) — 외래 키 → Roles.role_code — NOT NULL
  • content_id (PK2) — varchar(32) UUID — 외래 키 → Contents.content_id — NOT NULL
  • role_level (Field) — char(4) — NOT NULL

Roles (권한)

  • role_code (PK) — char(15) — 기본 키 — NOT NULL
  • role_description (Field) — varchar(255) — NOT NULL
  • use_yn (Field2) — char(1) — NOT NULL

Users (사용자 관리)

  • user_id (PK) — char(20) — 기본 키 — NOT NULL
  • role_code (PK2) — char(15) — 외래 키 → Roles.role_code — NOT NULL
  • user_name (Field) — varchar(100)
  • password (Field2) — varchar(40)
  • create_time (Field3) — datetime
  • creator (Field4) — char(20)
  • modify_time (Field5) — datetime
  • modifier (Field6) — char(20)
  • department (Field7) — char(20)
  • login_addres (Field8) — varchar(30)
  • login_date (Field12) — datetime
  • other_detail (Field9) — varchar(255)
  • use_yn (Field10) — char(1)
  • del_yn (Field11) — char(1)