moasam
Tables (13)
ai_generation_job
- id — BIGINT
- journal_id — BIGINT — Foreign key → observation_journal.id — NOT NULL
- requested_by — BIGINT — Foreign key → users.id — NOT NULL
- job_scope — VARCHAR(50) — NOT NULL
- target_section_type — VARCHAR(50)
- input_payload — JSON
- output_payload — JSON
- status — VARCHAR(50) — NOT NULL
- token_usage — INT
- error_message — TEXT
- started_at — DATETIME
- finished_at — DATETIME
- created_at — DATETIME — NOT NULL
auth_provider
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- provider_email — VARCHAR(255)
- linked_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
community_post
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- board_type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- view_count — INT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
community_reward_log
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- reward_type — VARCHAR(50) — NOT NULL
- source_type — VARCHAR(50) — NOT NULL
- source_id — BIGINT
- reward_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
daily_usage_quota
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- quota_date — DATE — NOT NULL
- base_quota — INT — NOT NULL
- reward_quota — INT — NOT NULL
- used_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- message — VARCHAR(2000) — NOT NULL
- target_type — VARCHAR(100)
- target_id — BIGINT
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
observation_journal
- id — BIGINT
- organization_id — BIGINT — Foreign key → organization.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- child_name — VARCHAR(100) — NOT NULL
- child_age — VARCHAR(50) — NOT NULL
- behavior_note — TEXT — NOT NULL
- curriculum_area — VARCHAR(100)
- area_decision_type — VARCHAR(50) — NOT NULL
- phone_consult_required — BOOLEAN — NOT NULL
- status — VARCHAR(50) — NOT NULL
- is_saved — BOOLEAN — NOT NULL
- saved_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
observation_section
- id — BIGINT
- journal_id — BIGINT — Foreign key → observation_journal.id — NOT NULL
- section_type — VARCHAR(50) — NOT NULL
- content — TEXT
- version — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
organization
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- code — VARCHAR(100) — NOT NULL
- domain — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post_attachment
- id — BIGINT
- post_id — BIGINT — Foreign key → community_post.id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- file_size — BIGINT — NOT NULL
- content_type — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
post_comment
- id — BIGINT
- post_id — BIGINT — Foreign key → community_post.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- parent_comment_id — BIGINT — Foreign key → post_comment.id
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_profile
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- organization_type — VARCHAR(50) — NOT NULL
- assigned_age_group — VARCHAR(50) — NOT NULL
- phone_consult_default — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- organization_id — BIGINT — Foreign key → organization.id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL