1
Tables (9)
Plant
- plantKey — INT
- plantName — VARCHAR(255) — NOT NULL
- plantStatus — ENUM('Seed', 'Germination', 'Seedling', 'Mature') — NOT NULL
PlantDict
- dictKey — INT
- getDate — DATETIME — NOT NULL
- getPlace — VARCHAR(255) — NOT NULL
- userKey — INT — NOT NULL
PlantDictPlantLink
- linkKey — INT
- userKey — INT — NOT NULL
- plantKey — INT — NOT NULL
PrivateCalendar
- privateCalendarKey — INT
- userKey — INT — NOT NULL
Project
- projectKey — INT
- totalPeople — INT — NOT NULL
- totalProgress — INT — NOT NULL
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
- projectName — VARCHAR(255) — NOT NULL
- taskCount — INT — NOT NULL
- plantKey — INT
- privateCalKey — INT
- currentProgress — VARCHAR(255) — NOT NULL
ProjectCalendar
- memoKey — INT
- memoName — VARCHAR(255) — NOT NULL
- calendarDate — DATETIME
- memo — TEXT — NOT NULL
- projectKey — INT — NOT NULL
- privateCalKey — INT
ProjectInfo
- projectInfoKey — INT
- userKey — INT — NOT NULL
- projectKey — INT — NOT NULL
- importance — BOOLEAN — NOT NULL
- authority — ENUM('ADMIN', 'MANAGER', 'MEMBER') — NOT NULL
TaskTable
- taskKey — INT
- taskName — VARCHAR(255) — NOT NULL
- taskProgress — VARCHAR(255) — NOT NULL
- taskStartDate — DATETIME — NOT NULL
- taskEndDate — DATETIME — NOT NULL
- userKey — INT — NOT NULL
- projectKey — INT — NOT NULL
- memoKey — INT
User
- userKey — INT
- userId — VARCHAR(255) — NOT NULL
- userName — VARCHAR(255) — NOT NULL
- userPassword — VARCHAR(255) — NOT NULL
- userEmail — VARCHAR(255) — NOT NULL
- gender — ENUM('MALE', 'FEMALE') — NOT NULL
- birth — DATETIME — NOT NULL
- mbti — ENUM('INTJ', 'INTP', 'ENTJ', 'ENTP', 'INFJ', 'INFP', 'ENFJ', 'ENFP', 'ISTJ', 'ISFJ', 'ESTJ', 'ESFJ', 'ISTP', 'ISFP', 'ESTP', 'ESFP') — NOT NULL