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)