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