관제그룹정보관리사이트
테이블 (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)