temp

Tables (26)

credit_transaction

  • id — bigint — Primary key — NOT NULL
  • member_id — varchar(36) — NOT NULL
  • amount — int — NOT NULL
  • type — varchar(30) — NOT NULL
  • ref_id — varchar(64)
  • created_at — datetime(6) — NOT NULL

exam

  • id — varchar(36) — Primary key — NOT NULL
  • owner_id — varchar(36) — NOT NULL
  • name — varchar(1024) — NOT NULL
  • status — varchar(20) — NOT NULL
  • folder_count — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • last_activity_at — timestamp — NOT NULL

exam_question

  • id — bigint — Primary key — NOT NULL
  • exam_id — varchar(36)
  • quiz_id — varchar(36) — NOT NULL
  • question_order — int — NOT NULL
  • question — varchar(2000) — NOT NULL
  • source_ref — varchar(255) — NOT NULL
  • answer_number — int — NOT NULL
  • selected_number — int

exam_question_choices

  • exam_question_id — bigint — Primary key — NOT NULL
  • choice_order — int — Primary key — NOT NULL
  • choice — varchar(2000) — NOT NULL

file

  • id — varchar(36) — Primary key — NOT NULL
  • member_id — varchar(36) — NOT NULL
  • name — varchar(1024) — NOT NULL
  • file_type — varchar(20) — NOT NULL
  • file_size — bigint — NOT NULL
  • url — varchar(1024) — NOT NULL
  • created_at — timestamp — NOT NULL
  • notion_page_id — varchar(255)

flyway_schema_history

  • installed_rank — int — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int — NOT NULL
  • success — tinyint(1) — NOT NULL

generation_usage

  • member_id — varchar(36) — Primary key — NOT NULL
  • period_key — varchar(32) — Primary key — NOT NULL
  • file_count — int — NOT NULL

invite_code

  • member_id — varchar(36) — Primary key — NOT NULL
  • code — varchar(8) — NOT NULL
  • created_at — datetime(6) — NOT NULL

invite_redemption

  • id — bigint — Primary key — NOT NULL
  • inviter_member_id — varchar(36)
  • invitee_member_id — varchar(36)
  • invitee_subject_hash — varchar(64) — NOT NULL
  • code — varchar(8) — NOT NULL
  • redeemed_at — datetime(6) — NOT NULL

member

  • member_id — varchar(36) — Primary key — NOT NULL
  • provider — varchar(20) — NOT NULL
  • external_subject — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • onboard_completed — tinyint(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • deleted_at — datetime(6)
  • terms_agreed — tinyint(1) — NOT NULL
  • terms_agreed_at — datetime(6)
  • terms_version — varchar(20)
  • apple_refresh_token — varchar(1024)

member_credit

  • member_id — varchar(36) — Primary key — NOT NULL
  • balance — int — NOT NULL
  • updated_at — datetime(6) — NOT NULL

member_setting

  • member_id — varchar(36) — Primary key — NOT NULL
  • lockscreen_enabled — tinyint(1) — NOT NULL
  • notification_granted — tinyint(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

member_subscription

  • member_id — varchar(36) — Primary key — NOT NULL
  • entitlement — varchar(50) — NOT NULL
  • store — varchar(30)
  • environment — varchar(20)
  • expires_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

notion_connection

  • id — varchar(36) — Primary key — NOT NULL
  • member_id — varchar(36) — NOT NULL
  • workspace_id — varchar(255) — NOT NULL
  • workspace_name — varchar(255) — NOT NULL
  • bot_id — varchar(255) — NOT NULL
  • access_token — varchar(255) — NOT NULL
  • sync_status — varchar(20) — NOT NULL
  • last_synced_at — timestamp
  • created_at — timestamp — NOT NULL

notion_image

  • id — varchar(36) — Primary key — NOT NULL
  • file_id — varchar(36) — NOT NULL
  • image_order — int — NOT NULL
  • object_key — varchar(1024) — NOT NULL
  • url — varchar(1024) — NOT NULL
  • file_type — varchar(20) — NOT NULL
  • image_size — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • downscaled — tinyint(1) — NOT NULL

notion_page

  • id — varchar(36) — Primary key — NOT NULL
  • connection_id — varchar(36) — NOT NULL
  • notion_page_id — varchar(255) — NOT NULL
  • title — varchar(1024) — NOT NULL
  • created_at — timestamp — NOT NULL

quiz

  • quiz_id — varchar(36) — Primary key — NOT NULL
  • folder_id — varchar(36)
  • question — text — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — tinyint(1) — NOT NULL
  • answer_number — int — NOT NULL
  • source_file_id — varchar(36)
  • source_name — varchar(1024)
  • source_type — varchar(20)

quiz_choices

  • quiz_id — varchar(36) — Primary key — NOT NULL
  • choice_order — int — Primary key — NOT NULL
  • choice — varchar(2000) — NOT NULL

quiz_folder

  • folder_id — varchar(36) — Primary key — NOT NULL
  • member_id — varchar(36) — NOT NULL
  • name — varchar(1024) — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — tinyint(1) — NOT NULL
  • is_example — tinyint(1) — NOT NULL

quiz_folder_source

  • folder_id — varchar(36) — Primary key — NOT NULL
  • file_id — varchar(255) — Primary key — NOT NULL
  • source_type — varchar(20) — NOT NULL

quiz_generation_job

  • job_id — varchar(36) — Primary key — NOT NULL
  • member_id — varchar(36) — NOT NULL
  • status — varchar(20) — NOT NULL
  • progress — int — NOT NULL
  • folder_id — varchar(36)
  • failure_code — varchar(40)
  • error_message — varchar(1024)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • folder_name — varchar(1024) — NOT NULL
  • charge_method — varchar(10)

quiz_generation_job_file

  • job_id — varchar(36) — Primary key — NOT NULL
  • file_order — int — Primary key — NOT NULL
  • file_id — varchar(255) — NOT NULL
  • file_name — varchar(1024) — NOT NULL
  • status — varchar(20) — NOT NULL
  • failure_code — varchar(40)
  • error_message — varchar(1024)

refresh_token

  • id — bigint — Primary key — NOT NULL
  • token_hash — varchar(255) — NOT NULL
  • member_id — varchar(36) — NOT NULL
  • expires_at — timestamp — NOT NULL

revenuecat_event

  • event_id — varchar(64) — Primary key — NOT NULL
  • received_at — timestamp — NOT NULL

review_card

  • quiz_id — varchar(36) — Primary key — NOT NULL
  • stability — double
  • difficulty — double
  • state — varchar(20) — NOT NULL
  • due_at — timestamp — NOT NULL
  • last_reviewed_at — timestamp
  • max_stability — double

review_log

  • id — varchar(36) — Primary key — NOT NULL
  • quiz_id — varchar(36) — NOT NULL
  • grade — varchar(20) — NOT NULL
  • overdue_days — int — NOT NULL
  • reviewed_at — timestamp — NOT NULL