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