obo

Tables (6)

content (콘텐츠)

  • 콘텐츠id (content_id) — bigint — Primary key — NOT NULL
  • 콘텐츠명 (content_text) — varchar

menu (메뉴)

  • 메뉴id (menu_id) — bigint — Primary key — NOT NULL
  • 메뉴이름 (menu_text) — varchar
  • 메뉴순서 (order) — bigint

menu_permission (CopyOf권한)

  • 메뉴id (menu_id) — bigint
  • 권한id (permission_id) — bigint
  • 생성권한 (create_permission) — boolean
  • 읽기권한 (read_permission) — boolean
  • 수정권한 (update_permission) — boolean
  • 삭제권한 (delete_permission) — boolean

permission (권한)

  • 권한id (permission_id) — bigint — Primary key — NOT NULL
  • 권한명 (permission_name) — varchar

translated_text (번역된 텍스트)

  • 권한id (permission_id) — bigint — Primary key — NOT NULL
  • 권한명 (permission_name) — varchar

user (유저)

  • 유저id (Key) — bigint — Primary key — NOT NULL
  • 성 (first_name) — varchar
  • 이름 (last_name) — varchar
  • 이메일 (email) — varchar
  • 휴대폰번호 (phone_number) — varchar
  • 아이디 (username) — varchar
  • 비밀번호 (password) — varchar
  • 프로필사진 (profile_img) — varchar
  • 권한id (permission_id) — bigint
  • 언어id (language_id) — bigint
  • 생성일자 (created_at) — time
  • 수정일자 (modified_at) — time
  • 최근로그인 (last_login) — time
  • 활성상태 (status) — enum