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