ccc
Tables (12)
count_sign_cert
- pk — char(36) — Primary key — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — varchar(255) — NOT NULL
- cn — varchar(128)
- cert — varchar(4000) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- certificateId — varchar(256)
display_info
- pk — char(36) — Primary key — NOT NULL
- mailbox_fk (mailbox) — char(36) — Foreign key → mailBox.pk — NOT NULL
- title — varchar(64)
- description — varchar(256)
- image_url — varchar(512)
enc_cert
- pk — char(36) — Primary key — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — varchar(255) — NOT NULL
- cn — varchar(128)
- cert — varchar(4000) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- certificateId — varchar(256)
friend_device
- pk — char(36) — Primary key — NOT NULL
- mailbox_fk (mailbox) — char(36) — Foreign key → mailBox.pk — NOT NULL
- friend_device_claim — char(36) — NOT NULL
- mailbox_request_id — char(36) — NOT NULL
- os_type — tinyint(4)
- push_token — varchar(128)
- created_date — timestamp — NOT NULL
- updated_date — timestamp — NOT NULL
mailBox
- pk — char(36) — Primary key — NOT NULL
- mailbox_identifier — varchar(128) — NOT NULL
- payload_type — varchar(32) — NOT NULL
- payload_data — varchar(4096) — NOT NULL
- expiration (expire_date) — datetime — NOT NULL
- created_date — timestamp — NOT NULL
- updated_date — timestamp — NOT NULL
- is_delete — bit(1) — NOT NULL
mailbox_access
- pk — char(36) — Primary key — NOT NULL
- mailbox_fk (mailbox) — char(36) — Foreign key → mailBox.pk — NOT NULL
- access_read — bit(1) — NOT NULL
- access_write — bit(1) — NOT NULL
- access_delete — bit(1) — NOT NULL
mailbox_history
- pk — char(36) — NOT NULL
- mailbox_identifier — varchar(128) — NOT NULL
- payload_type — varchar(32) — NOT NULL
- payload_data — varchar(4096) — NOT NULL
- created_date — timestamp — NOT NULL
- crud_type — tinyint(4) — NOT NULL
- owner_type — tinyint(4) — NOT NULL
- expiration — datetime — NOT NULL
owner_device
- pk — char(36) — Primary key — NOT NULL
- mailbox_fk (mailbox) — char(36) — Foreign key → mailBox.pk — NOT NULL
- owner_device_claim — char(36) — NOT NULL
- owner_device_attestation — varchar(128) — NOT NULL
- mailbox_request_id — char(36) — NOT NULL
- os_type — tinyint(4) — NOT NULL
- push_token — varchar(128) — NOT NULL
- created_date — timestamp — NOT NULL
- updated_date — timestamp — NOT NULL
pki_ca_cert
- pk — char(36) — Primary key — NOT NULL
- pki_root_fk (pki_root_cert_fk) — char(36) — Foreign key → pki_root_cert.pk — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — varchar(255) — NOT NULL
- cn — varchar(128)
- cert — varchar(4000) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- certificateId — varchar(256)
pki_root_cert
- pk — char(36) — Primary key — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — varchar(255) — NOT NULL
- cn — varchar(128)
- cert — varchar(4000) — NOT NULL
- issuer_id — varchar(20)
- subject_dn — varchar(100) — NOT NULL
- certificateId — varchar(256)
sign_cert
- pk — char(36) — Primary key — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — varchar(255) — NOT NULL
- cn — varchar(128)
- cert — varchar(4000) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- certificateId — varchar(256)
vehicle_oem_root
- pk — char(36) — Primary key — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — varchar(255) — NOT NULL
- cn — varchar(128)
- cert — varchar(4000) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- certificateId — varchar(256)