PASDSWORLD_FINAL
Tables (16)
authority
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- name — enum('PRIVATE_DATA_CREATE','PRIVATE_DATA_READ','PRIVATE_DATA_UPDATE','PRIVATE_DATA_DELETE','ROLE_CREATE','ROLE_UPDATE','ROLE_DELETE','TEAM_UPDATE','TEAM_DELETE','TEAM_INVITE','TEAM_REMOVE','PRIVATE_DATA_ROLE_UPDATE')
invitation
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- expired_at — datetime(6)
- invited_member_email — varchar(255)
- organization_role — enum('HEADER','ADMIN','MEMBER')
- member_id — bigint — Foreign key → member.id
- organization_id — bigint — Foreign key → organization.id
- role_id — bigint — Foreign key → role.id
- team_id — bigint — Foreign key → team.id
master_key
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- iv — varbinary(16)
- value — varbinary(32)
member
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- email — varchar(255)
- encrypted_totp_data_key — binary(48)
- encrypted_totp_iv — binary(32)
- encrypted_totp_key — binary(48)
- expired_at — datetime(6)
- master_key_version — bigint
- nickname — varchar(255)
- password — varchar(255)
- second_login_cnt — int — NOT NULL
member_organization
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- organization_role — enum('HEADER','ADMIN','MEMBER')
- member_id — bigint — Foreign key → member.id
- organization_id — bigint — Foreign key → organization.id
member_role
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- member_id — bigint — Foreign key → member.id
- role_id — bigint — Foreign key → role.id
- team_id — bigint — Foreign key → team.id
member_team
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- member_id — bigint — Foreign key → member.id
- team_id — bigint — Foreign key → team.id
notification
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- action_url — varchar(255)
- from_member — bigint
- from_member_nick_name — varchar(255)
- message — varchar(255)
- status — enum('READ','UNREAD')
- title — varchar(255)
- to_member — bigint
- to_member_nick_name — varchar(255)
- type — enum('SYSTEM','USER')
organization
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- name — varchar(255)
- team_count — int
- member_id — bigint — Foreign key → member.id
organization_dashboard
- id — bigint — Primary key — NOT NULL
- count — int — NOT NULL
- month — tinyint
- rotate — int — NOT NULL
- views — int — NOT NULL
- year — smallint
- organization_id — bigint — Foreign key → organization.id
private_data
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- content — blob
- count — int
- memo — varchar(255)
- private_data_id — varchar(255)
- title — varchar(255)
- type — enum('LOGIN','TEXT')
- url — varchar(255)
- team_id — bigint — Foreign key → team.id
private_data_role
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- privatedata_id — bigint — Foreign key → private_data.id
- role_id — bigint — Foreign key → role.id
role
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- name — varchar(255)
- team_id — bigint — Foreign key → team.id
role_authority
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- authority_id — bigint — Foreign key → authority.id
- role_id — bigint — Foreign key → role.id
team
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — bigint
- modified_at — datetime(6)
- modified_by — bigint
- encrypted_data_key — binary(48)
- encrypted_iv — binary(32)
- expired_at — datetime(6)
- master_key_version — bigint
- name — varchar(255)
- role_count — int
- secret_count — int
- member_id — bigint — Foreign key → member.id
- organization_id — bigint — Foreign key → organization.id
team_dashboard
- id — bigint — Primary key — NOT NULL
- count — int — NOT NULL
- month — tinyint
- rotate — int — NOT NULL
- views — int — NOT NULL
- year — smallint
- team_id — bigint — Foreign key → team.id