Masques documentation wiki

Masques is an open source, distributed, encrypted social network

User Tools

Site Tools


schema

Schema

ALBUM

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • NAME, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • SIZE_OF_ALL_FILES, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • COMMENTS, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL

FILE

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • NAME, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • PATH, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • ALBUM_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • MIME_TYPE, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • COMMENTS, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • SIZE, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL

FRIEND_REQUEST

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • REQUEST_STATUS, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • PROFILE_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • REQUESTED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • REQUEST_APPROVED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL

GROUPING

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • IDENTITY_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • USER_GENERATED, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • NAME, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL

GROUPING_PROFILE

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • GROUPING_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • PROFILE_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL

LOG

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • ACTION, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • NAME_SPACE, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • META_DATA, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • MESSAGE, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL

MESSAGE

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • SUBJECT, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • BODY, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL

PROFILE

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • ALIAS, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • ALIAS_NICK, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • TIME_ZONE, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • AVATAR_FILE_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • AVATAR_NICK_FILE_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • COMMENTS, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • IDENTITY, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • IDENTITY_ALGORITHM, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • PRIVATE_KEY, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • PRIVATE_KEY_ALGORITHM, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • DESTINATION, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL

PROPERTY

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • NAME, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • VALUE, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL

SHARE

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • MESSAGE_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • CONTENT_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • GROUP_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • CONTENT_TYPE, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • IDENTITY_TO, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • IDENTITY_TO_ALGORITHM, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • IDENTITY_FROM, TYPE CLOB(2147483647), NULL YES, KEY , DEFAULT NULL
  • IDENTITY_FROM_ALGORITHM, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • SHOWN_IN_STREAM_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • TRANSFERRED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
  • UUID, TYPE VARCHAR(255), NULL YES, DEFAULT NULL

USER

  • ID, TYPE BIGINT(19), NULL NO, KEY PRI, AUTO-INC
  • NAME, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • ENCRYPTED_PASSWORD, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • SALT, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • ENCRYPTED_PASSWORD_ALGORITHM, TYPE VARCHAR(255), NULL YES, KEY , DEFAULT NULL
  • ENCRYPTED_PASSWORD_N, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • PROFILE_ID, TYPE INTEGER(10), NULL YES, KEY , DEFAULT NULL
  • CREATED_AT, TYPE TIMESTAMP(23), NULL YES, KEY , DEFAULT NULL
schema.txt · Last modified: 2014/11/03 17:00 (external edit)