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