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