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