erd
Tables (10)
CareUser
- careuser_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- family_id — BIGINT — Foreign key → Home.home_id — NOT NULL — AUTO_INCREMENT
- image — TEXT
- nickname — VARCHAR(20)
Family
- user_family_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (user_id2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- home_id — BIGINT — Foreign key → Home.home_id — NOT NULL — AUTO_INCREMENT
Goal
- goal_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (user_id2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- type — ENUM — 물마시기, 금주하기, 금연하기, 운동하기
- start_date — TIMESTAMP — CURRENT_TIMESTAMP
- end_date — DATE
Home
- home_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- name — VARCHAR() — NOT NULL
- user_cnt — INT — NOT NULL — MAX_VALUE=6
- caring_cnt — INT — NOT NULL — MAX_VALUE=4
Hospital
- note_id — BIGINT — Foreign key → Note.note_id — NOT NULL
- type — ENUM — 외래, 입원, 응급
- hospital — VARCHAR(20)
- surgery — VARCHAR(10) — 검사, 시술, 수술
Medicine
- note_id — BIGINT — Foreign key → Note.note_id — NOT NULL
- medicine1 — VARCHAR(20)
- medicine2 — VARCHAR(20)
- medicine3 — VARCHAR(20)
- place — VARCHAR(20)
Note
- note_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (user_id2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- date — DATE
- title — VARCHAR(40)
- memo — TEXT
Symptom
- note_id — BIGINT — Foreign key → Note.note_id — NOT NULL
- symptom — VARCHAR(20)
Todo
- todo_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (user_id2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- content — VARCHAR(100)
- complete — BOOLEAN
- date — TIMESTAMP — CURRENT_TIMESTAMP
User
- user_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- name — VARCHAR(10) — NOT NULL
- phone — VARCHAR(11) — NOT NULL
- birth — DATE — NOT NULL
- email — VARCHAR(40) — NOT NULL
- gender — ENUM — NOT NULL — 남성, 여성
- password — VARCHAR(16) — NOT NULL — PW 제약조건 8~16자리
- image — TEXT
- nickname — VARCHAR(20) — 닉네임 제약조건 1~10자
- message — VARCHAR(40) — 20자 이내의 한글, 영문, 숫자
- family_cnt — INT — NOT NULL — MAX_VALUE=3