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