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