re-cloud

Tables (6)

directories

  • directory_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • parent_directory_id — BIGINT — Foreign key → directories.directory_id
  • name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

room_access_keys

  • access_key_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • key_hash — VARCHAR(255) — NOT NULL
  • can_view — TINYINT(1) — NOT NULL
  • can_upload — TINYINT(1) — NOT NULL
  • can_download — TINYINT(1) — NOT NULL
  • expires_at — DATETIME
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

room_participants

  • participant_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • room_access_key_id — BIGINT — Foreign key → room_access_keys.access_key_id
  • display_name — VARCHAR(50) — NOT NULL
  • guest_session_hash — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME — NOT NULL

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • created_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

shared_files

  • file_id — BIGINT — Primary key — NOT NULL
  • directory_id — BIGINT — Foreign key → directories.directory_id — NOT NULL
  • uploaded_by_participant_id — BIGINT — Foreign key → room_participants.participant_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • object_key — VARCHAR(500) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • checksum — VARCHAR(64)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL