loen

Tables (15)

app_notices

  • id — VARCHAR(255) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME

bible_notes

  • id — VARCHAR(255) — Primary key — NOT NULL
  • writer_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL
  • bible_name — VARCHAR(100)
  • bible_english_short — VARCHAR(20)
  • chapter — INT
  • phase_start — INT
  • phase_end — INT
  • title — VARCHAR(255)
  • description — TEXT
  • likes — JSON
  • is_hidden — BOOLEAN — NOT NULL
  • is_open_to_oikos — BOOLEAN — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

club_members

  • club_id — VARCHAR(255) — Foreign key → clubs.id — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL

clubs

  • id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • description — TEXT
  • created_at — DATETIME

comments

  • id — VARCHAR(255) — Primary key — NOT NULL
  • schedule_id — VARCHAR(255) — Foreign key → schedules.id — NOT NULL
  • writer_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

obs_content

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • bible_passage — VARCHAR(100) — NOT NULL
  • published_date — DATE — NOT NULL
  • sections — JSON — NOT NULL
  • is_published — BOOLEAN — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

obs_quiz

  • id — BIGINT — Primary key — NOT NULL
  • obs_content_id — BIGINT — Foreign key → obs_content.id — NOT NULL
  • step_number — INT — NOT NULL
  • question_type — VARCHAR(30) — NOT NULL
  • question_text — TEXT — NOT NULL
  • correct_answer — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

obs_review_history

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL
  • obs_content_id — BIGINT — Foreign key → obs_content.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • application_answer — TEXT
  • is_scraped — BOOLEAN — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

obs_review_history_emotions

  • emotion — VARCHAR(30) — Primary key — NOT NULL
  • obs_review_history_id — BIGINT — Foreign key → obs_review_history.id — NOT NULL

oikos

  • id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • leader_id — VARCHAR(255) — Foreign key → users.uid
  • sleader_id — VARCHAR(255) — Foreign key → users.uid
  • created_at — DATETIME

read_histories

  • id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL
  • accrued_read_count — INT — NOT NULL
  • today_read_count — INT — NOT NULL
  • read_check_list — JSON
  • last_updated_at — DATETIME

schedules

  • id — VARCHAR(255) — Primary key — NOT NULL
  • parent_id — VARCHAR(255)
  • title — VARCHAR(255) — NOT NULL
  • date — DATE
  • time — TIME
  • location — TEXT
  • created_at — DATETIME

thanks_notes

  • id — VARCHAR(255) — Primary key — NOT NULL
  • writer_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL
  • team_id — VARCHAR(255)
  • answer1 — TEXT
  • answer2 — TEXT
  • answer3 — TEXT
  • answer4 — TEXT
  • answer5 — TEXT
  • likes — JSON
  • is_fixed — BOOLEAN — NOT NULL
  • is_hidden — BOOLEAN — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

users

  • uid — VARCHAR(255) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100)
  • birthday — DATE
  • mbti — VARCHAR(10)
  • oikos_id — VARCHAR(255)
  • mission_team — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • profile_image — TEXT
  • hobbies — JSON
  • subscribes — JSON
  • created_at — DATETIME

worry_notes

  • id — VARCHAR(255) — Primary key — NOT NULL
  • writer_id — VARCHAR(255) — Foreign key → users.uid — NOT NULL
  • team_id — VARCHAR(255)
  • type — VARCHAR(50)
  • description — TEXT
  • is_hidden — BOOLEAN — NOT NULL
  • is_open_to_oikos — BOOLEAN — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME