naranhi
Tables (6)
children (Untitled2)
- Key — Primary key — NOT NULL
- user_id (Key3) — UUID — Foreign key → users.id — NOT NULL
- school_id (Key2) — Foreign key → schools.Key — NOT NULL
- nickname (Field) — TEXT
- grade (Field2) — INT
- class_name (Field3) — TEXT
- school_type (Field4) — ENUM
- allergies (Field5) — TEXT[]
- is_active (Field6) — BOOL
gcal_events (Untitled5)
- Key — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → users.id — NOT NULL
- child_id (Key3) — Foreign key → children.Key — NOT NULL
- Field
- Key (Key4) — Foreign key → notice_cards.Key — NOT NULL
notice_cards (Untitled6)
- Key — Primary key — NOT NULL
- notice_id (Key2) — Foreign key → notices.notice_id — NOT NULL
- card_type (Field) — ENUM(summary, supplies,todo,schedule,caution)
- title (Field2) — TEXT
- content (Field3) — TEXT
- event_date (Field6) — DATE
- event_type (Field7) — ENUM
notices (Untitled4)
- notice_id (Key) — Primary key — NOT NULL
- school_id (Key2) — Foreign key → schools.Key — NOT NULL
- brd_id (Field) — TEXT
- ntc_id (Field2) — TEXT
- school_domain (Field3) — TEXT
- title (Field4) — TEXT
- original_url (Field5) — TEXT
- raw_text_masked (Field6) — TEXT
- attachment_path (Field7)
- process_status (Field8) — ENUM
- badge_color (Field9) — ENUM
- category (Field10) — NUM
- target_grade (Field11) — INT(NULL=전체)
- traget_class (Field12) — INT(NULL=전체)
- published_at (Field13) — TIMESTAMP
- Field14
schools (Untitled3)
- Key — Primary key — NOT NULL
- neis_school_code (Field4) — TEXT
- name (Field) — TEXT
- shool_type (Field2) — ENUM(elem,mid)
- region (Field3) — TEXT
- edu_office_code (Field5) — TEXT(교육청 코드)
- homepage_rul (Field6) — TEXT
- crawl_board_url (Field7) — TEXT
- crawl_selector (Field8) — JSONB
- contact_email (Field9) — TEXt
- is_active (Field10) — BOOL
users (Untitled)
- id (Key) — UUID — Primary key — NOT NULL
- email (Field) — TEXT
- email_verified (Field2) — BOOL
- preferred_language (Field3) — ENUM
- display_name (Field4) — ENUM
- push_consent (Field5) — ENUM
- gcal_connected (Field6) — BOOL
- gcal_refresh_token (Field7) — TEXT
- is_active (Field8) — BOOL
- Field9