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