SubscLife

Tables (4)

REMIND (Untitled3)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • USER_ID (Key2) — BIGINT — Foreign key → USERS.ID — NOT NULL
  • TASKS_ID (Key3) — BIGINT — Foreign key → TASKS.ID — NOT NULL
  • ACHIEVEMENT_RATE (Field) — 0~100
  • ACHIEVE_REASON (Field2) — TEXT
  • FAIL_REASON (Field3) — TEXT
  • IMPROVEMENT_PLAN (Field4) — TEXT

SUBSCRIBE (Untitled4)

  • USER_ID (Key2) — BIGINT — Foreign key → USERS.ID — NOT NULL
  • TASK_ID (Key3) — BIGINT — Foreign key → TASKS.ID — NOT NULL

TASKS (Untitled2)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • USER_ID (Key2) — BIGINT — Foreign key → USERS.ID — NOT NULL
  • TITLE (Field) — VARCHAR(50)
  • SIMPLE_INFO (Field3) — VARCHAR(50)
  • DETAIL (Field2) — VARCHAR(255)
  • START_DATE (Field4) — DATETIME
  • END_DATE (Field5) — DATETIME

USERS (Untitled)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • ACCOUNT (Field2) — VARCHAR(50)
  • PASSWORD (Field3) — VARCHAR(50)
  • NAME (Field) — VARCHAR(50)
  • NICKNAME (Field4) — VARCHAR(50)