evolve_db
Tables (12)
attach_file (첨부파일 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- group_id (Field) — varchar(50)
- name (Field2) — varchar(50)
- save_name (Field3) — varchar(50)
- sort_order (Field8) — varchar(50)
- size (Field9) — varchar(50)
- extension (Field10) — varchar(50)
- path (Field11) — varchar(50)
- create_user_id (Field4) — varchar(50)
- created_at (Field5) — DATETIME
- update_user_id (Field6) — varchar(50)
- updated_at (Field7) — DATETIME
board (게시판 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- attach_file_group_Id (Key2) — varchar(50) — Foreign key → attach_file.id — NOT NULL
- content (Field2) — text
- title (Field3) — varchar(50)
- code_id (Field8) — varchar(50)
- create_user_id (Field4) — varchar(50)
- created_at (Field5) — DATETIME
- update_user_id (Field6) — varchar(50)
- updated_at (Field7) — DATETIME
code (코드 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- code_group_id (Key2) — varchar(50) — Foreign key → code_group.id — NOT NULL
- message_id (Key3) — text — Foreign key → message.id — NOT NULL
- name (Field3) — varchar(50)
- description (Field4) — varchar(255)
- sort_order (Field5) — number
- is_active (Field6) — Boolean
- create_user_id (Field7) — varchar(50)
- create_at (Field8) — Datetime
- update_user_id (Field9) — varchar(50)
- updated_at (Field10) — Datetime
code_group (코드 그룹 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- name (Field) — varchar(50)
- description (Field2) — varchar(255)
- sort_order (Field3) — number
- is_active (Field4) — Boolean
- create_user_id (Field5) — varchar(50)
- created_at (Field6) — DATETIME
- update_user_id (Field7) — varchar(50)
- updated_at (Field8) — DATETIME
log_access (접근로그 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- user_id (Field) — varchar(50)
- request_url (Field2) — text
- request_payload (Field3) — text
- request_ip (Field8) — varchar(50)
- method (Field9) — varchar(10)
- created_at (Field5) — DATETIME
log_login (로그인 로그 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- user_id (Field) — varchar(50)
- access_ip (Field8) — varchar(50)
- created_at (Field5) — DATETIME
menu (메뉴 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- message_id (Key2) — text — Foreign key → message.id — NOT NULL
- parent_menu_id (Field) — varchar(50)
- url (Field3) — varchar(50)
- name (Field4) — varchar(50)
- name (Field5) — varchar(50)
- is_active (Field6) — Boolean
- sort_order (Field7) — number
- description (Field8) — text
- level (Field9) — number
- create_user_id (Field10) — varchar(50)
- created_at (Field11) — DATETIME
- update_user_id (Field12) — varchar(50
- updated_at (Field13) — DATETIME
message (메시지 테이블)
- id (Key) — text — Primary key — NOT NULL
- language_code (Field) — varchar(4)
- text (Field2) — text
- is_active (Field3) — Boolean
- create_user_id (Field4) — varchar(50)
- created_at (Field5) — DATETIME
- update_user_id (Field6) — varchar(50)
- updated_at (Field7) — DATETIME
role (권한 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- name (Field) — varchar(50)
- description (Field2) — varchar(50)
- is_active (Field3) — varchar(50)
- create_user_id (Field4) — varchar(50)
- created_at (Field5) — DATETIME
- update_user_id (Field6) — varchar(50)
- updated_at (Field7) — DATETIME
role_menu (메뉴권한 테이블)
- role_id (Key) — varchar(50) — Primary key — NOT NULL
- menu_id (Key2) — varchar(50) — Foreign key → menu.id — NOT NULL
- message_id (Key22) — text — Foreign key → menu.message_id — NOT NULL
- create_user_id (Field4) — varchar(50)
- created_at (Field5) — DATETIME
- update_user_id (Field6) — varchar(50)
- updated_at (Field7) — DATETIME
role_user (유저권한 테이블)
- role_id (Key2) — varchar(50) — Foreign key → role.id — NOT NULL
- user_id (Key) — varchar(50) — Foreign key → user.id — NOT NULL
- create_user_id (Field4) — varchar(50)
- created_at (Field5) — DATETIME
- update_user_id (Field6) — varchar(50)
- updated_at (Field7) — DATETIME
user (회원 테이블)
- id (Key) — varchar(50) — Primary key — NOT NULL
- ko_name (Field) — varchar(50)
- en_name (Field2) — varchar(50)
- email (Field3) — varchar(50)
- phone_number (Field4) — varchar(50)
- password (Field5) — varchar(50)
- is_active (Field6) — Boolean
- create_at (Field7) — DATETIME
- updated_at (Field8) — DATETIME