loen2
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)
- owner_uid — VARCHAR(255) — Foreign key → users.uid — 일정 생성자/소유자
- target_type — VARCHAR(50) — PERSONAL, OIKOS, PUBLIC 등
- target_id — VARCHAR(255) — OIKOS_ID 등 (type에 따라 다름)
- 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) — Foreign key → oikos.id
- 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) — Foreign key → oikos.id
- 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) — Foreign key → oikos.id
- type — VARCHAR(50)
- description — TEXT
- is_hidden — BOOLEAN — NOT NULL
- is_open_to_oikos — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME