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