1
Tables (14)
AI_CHAT_HISTORIES
- chat_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- child_id — NUMBER(10) — Foreign key → CHILDREN.child_id
- question — VARCHAR2(1000) — NOT NULL
- answer — CLOB
- created_at — DATE
BUDGETS
- budget_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- month_yyyymm — CHAR(6) — NOT NULL
- category — VARCHAR2(30) — NOT NULL
- budget_amount — NUMBER(12,2) — NOT NULL
- created_at — DATE
CHILDREN
- child_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- child_name — VARCHAR2(30) — NOT NULL
- nickname — VARCHAR2(30)
- gender — CHAR(1)
- birth_date — DATE
- profile_image_url — VARCHAR2(500)
- status — CHAR(1)
- created_at — DATE
CHILD_RECORDS
- record_id — NUMBER(10) — Primary key — NOT NULL
- child_id — NUMBER(10) — Foreign key → CHILDREN.child_id — NOT NULL
- record_type — VARCHAR2(30) — NOT NULL
- record_datetime — DATE — NOT NULL
- numeric_value — NUMBER
- text_value — VARCHAR2(500)
- memo — VARCHAR2(500)
- created_at — DATE
CONTENTS
- content_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id
- category — VARCHAR2(30)
- title — VARCHAR2(200) — NOT NULL
- content_type — VARCHAR2(20)
- content — CLOB
- thumbnail_url — VARCHAR2(500)
- view_count — NUMBER
- like_count — NUMBER
- created_at — DATE
- status — CHAR(1)
CONTENT_COMMENTS
- comment_id — NUMBER(10) — Primary key — NOT NULL
- content_id — NUMBER(10) — Foreign key → CONTENTS.content_id — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- parent_comment_id — NUMBER(10) — Foreign key → CONTENT_COMMENTS.comment_id
- comment_text — VARCHAR2(1000) — NOT NULL
- created_at — DATE
- status — CHAR(1)
CONTENT_LIKES
- like_id — NUMBER(10) — Primary key — NOT NULL
- content_id — NUMBER(10) — Foreign key → CONTENTS.content_id — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- created_at — DATE
EXPENSES
- expense_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- child_id — NUMBER(10) — Foreign key → CHILDREN.child_id
- expense_date — DATE — NOT NULL
- category — VARCHAR2(30) — NOT NULL
- amount — NUMBER(12,2) — NOT NULL
- payment_method — VARCHAR2(20)
- memo — VARCHAR2(300)
- created_at — DATE
FAVORITES
- favorite_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- content_id — NUMBER(10) — Foreign key → CONTENTS.content_id
- target_type — VARCHAR2(20)
- target_id — NUMBER(10)
- created_at — DATE
INCOMES
- income_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- income_date — DATE — NOT NULL
- source — VARCHAR2(100)
- amount — NUMBER(12,2) — NOT NULL
- memo — VARCHAR2(300)
- created_at — DATE
RECOMMENDATIONS
- recommendation_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- content_id — NUMBER(10) — Foreign key → CONTENTS.content_id
- recommend_type — VARCHAR2(20)
- title — VARCHAR2(200)
- reason — VARCHAR2(1000)
- created_at — DATE
REVIEWS
- review_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- target_type — VARCHAR2(20) — NOT NULL
- target_id — NUMBER(10) — NOT NULL
- rating — NUMBER(2)
- review_title — VARCHAR2(200)
- review_content — VARCHAR2(2000)
- like_count — NUMBER
- created_at — DATE
- status — CHAR(1)
SCHEDULES
- schedule_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USERS.user_id — NOT NULL
- child_id — NUMBER(10) — Foreign key → CHILDREN.child_id
- category — VARCHAR2(50)
- title — VARCHAR2(200) — NOT NULL
- description — VARCHAR2(1000)
- start_datetime — DATE — NOT NULL
- end_datetime — DATE
- location — VARCHAR2(200)
- memo — VARCHAR2(500)
- is_alarm_enabled — CHAR(1)
- created_at — DATE
USERS
- user_id — NUMBER(10) — Primary key — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- password_hash — VARCHAR2(200) — NOT NULL
- user_name — VARCHAR2(50) — NOT NULL
- nickname — VARCHAR2(50)
- phone — VARCHAR2(20)
- profile_image_url — VARCHAR2(500)
- role — VARCHAR2(20)
- status — CHAR(1)
- join_date — DATE
- created_at — DATE
- updated_at — DATE