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