Rootin
Tables (20)
AI_RESULT
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- til_id — BIGINT — Foreign key → TIL.id — NOT NULL
- tool_type — VARCHAR(20) — NOT NULL
- result_content — LONGTEXT — NOT NULL
- question_count — INT
- difficulty — VARCHAR(10)
- created_at — DATETIME — NOT NULL
BADGE
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- condition_type — VARCHAR(50) — NOT NULL
- condition_value — INT — NOT NULL
BOOKMARK
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- til_id — BIGINT — Foreign key → TIL.id — NOT NULL
- created_at — DATETIME — NOT NULL
COMMENT
- id — BIGINT — Primary key — NOT NULL
- til_id — BIGINT — Foreign key → TIL.id — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
DRAFT
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- pot_id — BIGINT — Foreign key → POT.id
- title — VARCHAR(255)
- content — LONGTEXT
- saved_at — DATETIME — NOT NULL
FOLLOW
- follower_id — BIGINT — Foreign key → USER.id — NOT NULL
- followee_id — BIGINT — Foreign key → USER.id — NOT NULL
- created_at — DATETIME — NOT NULL
LIKES
- til_id — BIGINT — Foreign key → TIL.id — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- created_at — DATETIME — NOT NULL
NOTIFICATION
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
PLANT
- id — BIGINT — Primary key — NOT NULL
- pot_id — BIGINT — Foreign key → POT.id — NOT NULL
- growth_stage — VARCHAR(20) — NOT NULL
- level — INT — NOT NULL
- harvested_at — DATETIME
- created_at — DATETIME — NOT NULL
PLANT_COLLECTION
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- plant_id — BIGINT — Foreign key → PLANT.id — NOT NULL
- plant_type — VARCHAR(50) — NOT NULL
- level_at_harvest — INT — NOT NULL
- collected_at — DATETIME — NOT NULL
POINT_LOG
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- amount — INT — NOT NULL
- reason — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
POT
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- level — INT — NOT NULL
- total_exp — INT — NOT NULL
- created_at — DATETIME — NOT NULL
REFRESH_TOKEN
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- token — VARCHAR(512) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
TAG
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
TEMPLATE
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- is_default — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
TIL
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- pot_id — BIGINT — Foreign key → POT.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT — NOT NULL
- is_public — TINYINT(1) — NOT NULL
- allow_comment — TINYINT(1) — NOT NULL
- char_count — INT — NOT NULL
- published_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
TIL_TAG
- til_id — BIGINT — Foreign key → TIL.id — NOT NULL
- tag_id — BIGINT — Foreign key → TAG.id — NOT NULL
USER
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(500)
- bio — VARCHAR(255)
- provider — VARCHAR(20)
- provider_id — VARCHAR(255)
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
USER_BADGE
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- badge_id — BIGINT — Foreign key → BADGE.id — NOT NULL
- earned_at — DATETIME — NOT NULL
WATERING_LOG
- id — BIGINT — Primary key — NOT NULL
- pot_id — BIGINT — Foreign key → POT.id — NOT NULL
- til_id — BIGINT — Foreign key → TIL.id — NOT NULL
- exp_gained — INT — NOT NULL
- watered_at — DATETIME — NOT NULL