security

Tables (7)

member

  • member_no — BIGINT(20) — Primary key — NOT NULL
  • member_social_no — BIGINT(20)
  • email — VARCHAR(255) — NOT NULL — 이메일' COLLATE 'utf8_general_ci
  • id — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • type — ENUM('DEFAULT', 'OAUTH')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • use_yn — CHAR(1) — NOT NULL

member_role_mapping

  • member_role_mapping_no — BIGINT(20) — Primary key — NOT NULL
  • member_no — BIGINT(20) — NOT NULL
  • role_no — BIGINT(20) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • INDEX — `member_no`
  • INDEX — `role_no`

member_social

  • member_social_no — BIGINT(20) — Primary key — NOT NULL
  • member_no — BIGINT(20) — Foreign key → member.member_no — NOT NULL
  • provider — ENUM('KAKAO','GOOGLE','NAVER') — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • access_token — VARCHAR(255) — NOT NULL
  • refresh_token — VARCHAR(255) — NOT NULL
  • expired_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

resources

  • resource_no — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • http_method — VARCHAR(50)
  • order_num — INT(10)
  • type — VARCHAR(50) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

role

  • role_no — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(20)
  • use_yn — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

role_hierarchy

  • role_hierarchy_no — BIGINT(20) — Primary key — NOT NULL
  • parent_name — VARCHAR(50) — NOT NULL
  • child_name — VARCHAR(50) — NOT NULL

role_resources_mapping

  • role_no (role_no2) — BIGINT(20) — Foreign key → role.role_no — NOT NULL
  • resource_no (resource_no2) — BIGINT(20) — Foreign key → resources.resource_no — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP