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