shinhan

Tables (7)

auto_transfer

  • id — bigint — Primary key — NOT NULL
  • auto_date — datetime — NOT NULL
  • money — int — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • deleted_at — datetime
  • Field — VARCHAR(255)
  • family_id — bigint — Foreign key → family.id — NOT NULL

diary

  • id — bigint — Primary key — NOT NULL — auto_increment
  • date — datetime — NOT NULL
  • daily_score — int
  • family_id — Long — Foreign key → family.id — NOT NULL
  • feedback — bigint — Foreign key → feedback.id

family

  • id — bigint — Primary key — NOT NULL
  • family_name — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • deleted_at — datetime

feedback

  • id — bigint — Primary key — NOT NULL
  • contents — varchar(255)
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • deleted_at — datetime
  • user_id — bigint — Foreign key → users.id — NOT NULL

mission

  • id — bigint — Primary key — NOT NULL
  • mission_name — varchar(255) — NOT NULL
  • reward — int — NOT NULL
  • p_f — boolean — NOT NULL
  • goal — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • deleted_at — datetime
  • picture — varchar(255)
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • allow — boolean

montly_goal_money

  • id — bigint — Primary key — NOT NULL
  • date — date — NOT NULL — 년월
  • goal_money — int — NOT NULL
  • Field3 — VARCHAR(255)
  • user_id — bigint — Foreign key → users.id — NOT NULL — 부모만

users

  • id — bigint — Primary key — NOT NULL
  • role — varchar(10) — NOT NULL — 부모, 자녀
  • user_name — varchar(20) — NOT NULL
  • family_id — Long — Foreign key → family.id
  • account — int — NOT NULL
  • user_id — varchar(30) — NOT NULL
  • password — varchar(30) — NOT NULL
  • credit_score — int — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • deleted_at — datetime