bunny

Tables (5)

User (user)

  • id (user_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field (birth) — date
  • Field (gender) — enum
  • Field (standard) — enum
  • Field2 (job) — enum
  • Field (money) — BIGINT
  • Field (work_day) — enum
  • Field (working_time) — LocalDateTime
  • Field (qutting_time) — LocalDateTime
  • Field (created_at) — LocalDateTime
  • Field (updated_at) — LocalDateTime

category (아끼기 카테고리)

  • id (category_id) — BIGINT — Primary key — NOT NULL
  • Field (category_name) — VARCHAR
  • Field (detail) — VARCHAR
  • Field (one_price) — BIGINT
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL

salary (유저 관련 급여)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (month_money) — Integer
  • Field (week_money) — Integer
  • Field (day_money) — Integer
  • Field (hour_money) — Integer
  • Field (min_money) — BIGINT
  • Field (second_money) — BIGINT
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL

save (아끼기)

  • id (save_id) — BIGINT — Primary key — NOT NULL
  • Field (saving_chance) — INT
  • Field (day) — TIMESTAMP
  • Field (saving_price) — BIGINT
  • id (category_id) — BIGINT — Foreign key → category.id — NOT NULL

target (목표)

  • Key (target_id) — BIGINT — Primary key — NOT NULL
  • Field (total_target_amount) — BIGINT
  • Field (target_amount) — BIGINT
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL