FSHS
Tables (6)
file
- id — integer — Primary key — NOT NULL
- audio_codec — varchar(255)
- base_name — varchar(255) — NOT NULL
- bitrate — integer
- captured_at — timestamp
- category — varchar(20) — NOT NULL
- created_at — timestamp — NOT NULL
- duration — bigint
- extension — varchar(50) — NOT NULL
- format — varchar(255)
- fps — float
- height — integer
- lat — float
- lon — float
- lower_name — varchar(255) — NOT NULL
- mime_type — varchar(255)
- name — varchar(255) — NOT NULL
- orientation — integer
- origin_updated_at — timestamp — NOT NULL
- owner_id — bigint
- parent_path — varchar(4096) — NOT NULL
- relative_path — varchar(4096) — NOT NULL
- size — bigint — NOT NULL
- updated_at — timestamp — NOT NULL
- uuid — varchar(40) — NOT NULL
- video_codec — varchar(255)
- width — integer
- parent_folder_id — integer — Foreign key → folder.id
folder
- id — integer — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- is_root — boolean — NOT NULL
- is_system_root — boolean — NOT NULL
- lower_name — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- origin_updated_at — timestamp — NOT NULL
- owner_id — bigint
- relative_path — varchar(4096) — NOT NULL
- updated_at — timestamp — NOT NULL
- parent_folder_id — integer — Foreign key → folder.id — NOT NULL
member
- id — integer — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- password — varchar(100) — NOT NULL
- updated_at — timestamp — NOT NULL
- user_role — varchar(20) — NOT NULL
- username — varchar(255) — NOT NULL
- root_folder_id — integer — Foreign key → folder.id
persistent_logins
- series — VARCHAR(64) — Primary key — NOT NULL
- username — VARCHAR(64) — NOT NULL
- token — VARCHAR(64) — NOT NULL
- last_used — DATETIME — NOT NULL
shared_file
- id — integer — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- share_key — varchar(50) — NOT NULL
- updated_at — timestamp — NOT NULL
- owner_id — integer — Foreign key → member.id — NOT NULL
- file_id — integer — Foreign key → file.id — NOT NULL
transcoding_setting
- id — integer — Primary key — NOT NULL
- hw_accel — varchar(20) — NOT NULL
- h264_encoder — varchar(30) — NOT NULL
- quality — varchar(10) — NOT NULL