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