HAUS
Tables (6)
family (Untitled2)
- id (Key) — BiGINT — Primary key — NOT NULL
- name (Field) — TEXT
member (Untitled)
- id (회원 idx) — BiGINT — Primary key — NOT NULL
- family_id (가족 idx) — BiGINT — Foreign key → family.id — NOT NULL
- nickname (ex) 딸) — TEXT
- email (이메일) — TEXT
- intro (자기소개) — TEXT
- image (프로필 url) — TEXT
- social_type (소셜 타입) — INT
- social_id (소셜 고유 idx) — INT
notification (Untitled4)
- id (알림 idx) — BiGINT — Primary key — NOT NULL
- routine_id (루틴 idx) — BiGINT — Foreign key → routine.id — NOT NULL
- receiver_id (요청 받은 회원 idx) — BiGINT — Foreign key → member.id — NOT NULL
- requester_id (요청자 idx) — BiGINT
- accept (수락 여부) — TINYINT
routine (Untitled3)
- id (루틴 idx) — BiGINT — Primary key — NOT NULL
- requester_id (요청자 idx) — BiGINT
- title (제목) — TEXT
- sub_title (요청 메세지) — TEXT
- start_date (시작 날짜) — DATETIME
- finish_date (완료 날짜) — DATETIME
- image (이미지 url) — TEXT
- comment (완료 후기) — TEXT
- created_date (생성 날짜) — DATETIME
- updated_date (수정 날짜) — DATETIME
routine_completed (Untitled6)
- routine_id (루틴 idx) — BiGINT — Foreign key → routine.id — NOT NULL
- member_id (회원 idx) — BiGINT — Foreign key → member.id — NOT NULL
- is_completed (완료 여부) — TINYINT
- comment (후기) — TEXT
- image (후기 사진) — TEXT
- created_date (생성날짜) — DATETIME
routine_repeat (Untitled7)
- routine_repeat_id (Key) — BiGINT — Primary key — NOT NULL
- id (루틴 idx2) — BiGINT — Foreign key → routine.id — NOT NULL
- routine_id (루틴 idx) — BIGINT
- day (1(일)~7(토)) — INT
- flag (Y/N) — TINYINT