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