advanced
Tables (11)
audio_data
- id — BIGSERIAL
- folder_id — BIGINT — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- duration — INT
- language — VARCHAR(50)
- created_at — TIMESTAMP
boards
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
folders
- id — BIGSERIAL
- board_id — BIGINT — NOT NULL
- parent_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
invitations
- id — BIGSERIAL
- room_id — BIGINT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- status — VARCHAR(50)
- invited_by — BIGINT
- invited_at — TIMESTAMP
memos
- id — BIGSERIAL
- transcript_id — BIGINT — NOT NULL
- user_id — BIGINT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
room_members
- id — BIGSERIAL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- role — VARCHAR(50)
- invited_at — TIMESTAMP
rooms
- id — BIGSERIAL
- board_id — BIGINT — NOT NULL
- owner_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
subscriptions
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- plan_type — VARCHAR(50) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- is_active — BOOLEAN
- payment_info — JSONB
- created_at — TIMESTAMP
summaries
- id — BIGSERIAL
- audio_id — BIGINT — NOT NULL
- summary_type — VARCHAR(50)
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
transcripts
- id — BIGSERIAL
- audio_id — BIGINT — NOT NULL
- speaker_label — VARCHAR(50)
- start_time — FLOAT
- end_time — FLOAT
- text — TEXT — NOT NULL
- corrected_text — TEXT
- created_at — TIMESTAMP
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(100)
- role — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- Field