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