smartQuest

Tables (9)

childrefreshtoken

  • token_id — BIGINT — Primary key — NOT NULL — 자녀 리프레시 토큰 ID
  • child_id — BIGINT — NOT NULL — 자녀 ID
  • refresh_token — VARCHAR(255) — NOT NULL — 리프레시 토큰
  • created_at — DATETIME
  • expires_at — DATETIME

children

  • child_id — BIGINT — Primary key — NOT NULL — 자녀 ID
  • name — VARCHAR(255)
  • age — INT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • created_at — DATETIME

parentrefreshtoken

  • token_id — BIGINT — Primary key — NOT NULL — 부모 리프레시 토큰 ID
  • parents_id — BIGINT — NOT NULL — 부모 ID
  • refresh_token — VARCHAR(255) — NOT NULL — 리프레시 토큰
  • created_at — DATETIME
  • expires_at — DATETIME

parents

  • parents_id — BIGINT — Primary key — NOT NULL — 부모 ID
  • name — VARCHAR(255)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

parents_child

  • parents_id — BIGINT — Foreign key — NOT NULL
  • child_id — BIGINT — Foreign key — NOT NULL
  • relationship_status — VARCHAR(255) — 예: 등록, 활성화, 비활성화 등

parents_children

  • parents_id — BIGINT — Foreign key → parents.parents_id — NOT NULL
  • child_id — BIGINT — Foreign key → children.child_id — NOT NULL
  • relationship_status — VARCHAR(255) — 부모와 자녀 간의 관계 상태

point

  • point_id — BIGINT — Primary key — NOT NULL — 포인트 ID
  • child_id — BIGINT — Foreign key → children.child_id — NOT NULL
  • parents_id — BIGINT — Foreign key → parents.parents_id — NOT NULL
  • amount — INT
  • earned_at — DATETIME

quest

  • quest_id — BIGINT — Primary key — NOT NULL — 퀘스트 ID
  • parents_id — BIGINT — Foreign key → parents.parents_id — NOT NULL
  • child_id — BIGINT — Foreign key → children.child_id — NOT NULL
  • title — VARCHAR(255)
  • description — VARCHAR(255)
  • reward — INT
  • created_quest — DATETIME
  • updated_quest — DATETIME
  • status — VARCHAR(255) — 퀘스트 상태
  • due_date — DATETIME

reward

  • reward_id — BIGINT — Primary key — NOT NULL
  • quest_id — BIGINT — Foreign key → quest.quest_id — NOT NULL
  • parents_id — BIGINT — Foreign key → parents.parents_id — NOT NULL
  • child_id — BIGINT — Foreign key → children.child_id — NOT NULL
  • point — INT
  • value — INT