Daily Check

Tables (3)

habit_records (습관 완료 기록)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • habit_id (FK) — BIGINT
  • record_date (Field) — DATE
  • status (Field1) — VARCHAR(20)
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

habits (사용자 습관)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK) — BIGINT
  • title (Field) — VARCHAR(100)
  • description (Field1) — VARCHAR(255)
  • status (Field2) — VARCHAR(20)
  • created_at (Field3) — DATETIME
  • updated_at (Field5) — DATETIME

members (회원 정보 / 로그인)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • password (Field1) — VARCHAR(255)
  • nickname (Field2) — VARCHAR(50)
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME