zerothon
Tables (4)
Notification (알림)
- ID (PK) — INTEGER — Primary key — NOT NULL
- Type (Field) — VARCHAR(10)
- State (Field2) — VARCHAR(10)
- RequesterID (FK) — INTEGER
- Content (Field3) — VARCHAR(500)
- ResponserID (FK2) — INTEGER
- Field4 — INTEGER
TODO (목표)
- ID (PK) — INTEGER — Primary key — NOT NULL
- Title (Field) — VARCHAR(100)
- Content (Field2) — VARCHAR(500)
- StartDate (Field3) — DATETIME
- EndDate (Field4) — DATETIME
- BuddyID (FK2) — INTEGER
- UserID (FK) — INTEGER — Foreign key → User.ID — NOT NULL
- CreatedAt (Field5) — DATETIME
- State (Field6) — VARCHAR(10)
User (사용자)
- ID (PK) — INTEGER — Primary key — NOT NULL
- Name (Field) — VARCHAR(20)
- LoginID (Field2) — VARCHAR(30)
- Password (Field3) — VARCHAR(30)
- CreatedAt (Field4) — DATETIME
buddy (버디)
- ID (PK) — INTEGER — Primary key — NOT NULL
- Requester (FK) — INTEGER — Foreign key → User.ID — NOT NULL
- Responser (FK2) — INTEGER
- State (Field2) — VARCHAR(10)
- CreatedAt (Field) — DATETIME