ㅅㅅㄷㄴㅅ
Tables (5)
department
- dept_no — bigint(20) — Primary key — NOT NULL
- dept_name — varchar(100) — NOT NULL
- parent_dept_no — bigint(20)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
employee
- id — bigint(20) — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- email — varchar(254) — NOT NULL
- nickname — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- phone_number — varchar(13) — NOT NULL
- profile_file_url — varchar(500)
- failed_login_count — int(11) — NOT NULL
- locked_until — datetime(6)
- last_login_at — datetime(6)
- gender — varchar(10) — NOT NULL
- role — varchar(20) — Foreign key → role_code.code — NOT NULL
- dept_no — bigint(20) — Foreign key → department.dept_no
- manager_id — bigint(20) — NOT NULL
- approved — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
member
- id — bigint(20) — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- email — varchar(254) — NOT NULL
- nickname — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- phone_number — varchar(13) — NOT NULL
- profile_file_url — varchar(500)
- failed_login_count — int(11) — NOT NULL
- locked_until — datetime(6)
- last_login_at — datetime(6)
- gender — varchar(10) — NOT NULL
- role — varchar(20) — Foreign key → role_code.code — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
post
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- author_username — varchar(50) — Foreign key → employee.username — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
role_code
- id — bigint(20) — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- description — varchar(255) — NOT NULL
- level — int(11) — NOT NULL
- enabled — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL