erd
Tables (15)
Untitled (USER)
- Key (ID) — VARCHAR2 — Primary key — NOT NULL
- Field (PASSWORD) — VARCHAR2
- Field (NICKNAME) — VARCHAR2
- Field (EMAIL) — VARCHAR2
Untitled (PLANT)
- Key (PLANT_NUMBER) — NUMBER — Primary key — NOT NULL
- Field2 (PLANT_NAME) — VARCHAR2
- Field3 (CYCLE) — NUMBER
- Field4 (TEMPERATURE) — NUMBER
- Field (HUMIDITY) — NUMBER
- Field (UV) — NUMBER
Untitled (REACT)
- Key (CATEGORIZE_NUM) — NUMBER — Primary key — NOT NULL
- Field (CATEGORIZE) — VARCHAR2
- Field2 (REACTS) — VARCHAR2
Untitled (PLANT_CARE)
- Key (PLANTCARE_SEQ) — NUMBER — Primary key — NOT NULL
- Field (LAST_DATE) — DATE
- Field (PLANT_DIARY) — VARCHAR2
- Field (PLANT_HEIGHT) — NUMBER
- Key (PLANT_SEQ) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (RECOMMEND)
- Key (RECOMMEND_NUM) — NUMBER — Primary key — NOT NULL
- Field (RECOMMEND_PLANT) — VARCHAR2
- Field (FILELOCATION) — VARCHAR2
Untitled (CHALLENGE)
- Key (CHALLENGE_NUM) — NUMBER — Primary key — NOT NULL
- Field (CHALLENGE_NAME) — VARCHAR2
- Field (CONTENTS) — VARCHAR2
- Field (SCORE) — NUMBER
Untitled (COMMENT)
- Key (COMMENT_NUM) — NUMBER — Primary key — NOT NULL
- Field (COMMENT_CONTENTS) — VARCHAR2
- Field (RAGE_DATE) — DATE
- Key (POST_NUMBER) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
- Key (ID) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
Untitled (USER_GRADE)
- Key (USER_GRADE_SEQ) — NUMBER — Primary key — NOT NULL
- Key (ID) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
- Key (GRADE2) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
Untitled (GRADE)
- Key (GRADE) — VARCHAR2 — Primary key — NOT NULL
- Field (EXP) — NUMBER
- Field (GRADEEMOTHION) — VARCHAR2
Untitled (USER_CHALL)
- Key (USER_CHALLENGE_NUM) — NUMBER — Primary key — NOT NULL
- Field (CHECK_CHALL) — VARCHAR2
- Key (CHALLENGE_NUM2) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (ID) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
Untitled (GARDEN)
- Key (PLANT_SEQ) — NUMBER — Primary key — NOT NULL
- Field (PLANT_NICKNAME)
- Key (ID) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
- Key (PLANT_NUMBER) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (QUESTION)
- Key (QUESTION_NEM) — NUMBER — Primary key — NOT NULL
- Field (QUESTION_CONTENTS)
- Key (RECOMMEND_NUM) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (CHOICE1)
- Key (CHOICE1_NUM) — NUMBER — Primary key — NOT NULL
- Field (CHOICE_CONTENTS) — VARCHAR2
- Key (QUESTION_NEM) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (CHOICE2)
- Key (CHOICE2_NUM) — NUMBER — Primary key — NOT NULL
- Field (CHOICE_CONTENTS) — VARCHAR2
- Key (QUESTION_NEM) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled2 (COMMUNITY)
- Key (POST_NUMBER) — NUMBER — Primary key — NOT NULL
- Field2 (POST_NAME) — VARCHAR2
- Field (POST_CONTENTS) — VIEW_COUNT
- Field (VIEW_COUNT) — NUMBER
- Key (ID) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL