ㅅㅅㄷㄴㅅ

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