dd

Tables (7)

Admin

  • Admin_Number (PK) — int — Primary key — NOT NULL
  • Id — varchar(100)
  • Name — varchar(100)
  • Password — varchar(100)
  • Date — varchar(100)

Chatbot

  • Chatbot_id (PK) — varchar — Primary key — NOT NULL
  • Plant_Number (FK) — int — Foreign key → Plant.Plant_Number — NOT NULL
  • User_Id (PK2) — varchar(100) — Foreign key → User.User_Id — NOT NULL

Mypage

  • Mypage_id (PK) — varcher(100) — Primary key — NOT NULL
  • User_Id (FK1) — varchar(100) — Foreign key → User.User_Id — NOT NULL
  • Useredit_id (FK2) — varchar(100) — Foreign key → Useredit.Useredit_id — NOT NULL
  • Secession — varchar(100) — 탈퇴

Plant

  • Plant_Number (PK) — int — Primary key — NOT NULL
  • Photo_No — int
  • Photo — varchar
  • Name — varchar(100)
  • Place — varchar(100)
  • Water — varchar(100)
  • Size — varchar(100)
  • Formaldehyde — double
  • Carbondioxide — double
  • Negativeion — int
  • Relativehumidity — double

SignUp

  • Signup_Id (PK) — varchar(100) — Primary key — NOT NULL
  • Name — varchar(100)
  • Password — varchar(100)
  • Password_Repeat — varchar(100)
  • Birth — varchar(100)
  • Phone — int

User

  • User_Id (PK) — varchar(100) — Primary key — NOT NULL
  • Signup_Id (FK2) — varcher(100) — Foreign key → SignUp.Signup_Id — NOT NULL
  • Admin_Number (FK) — int — Foreign key → Admin.Admin_Number — NOT NULL
  • Password — varchar(100)
  • Name — varchar(100)
  • Sex — varchar(100)
  • Birth — varchar(100)
  • Phone — int
  • Email — varchar(100)

Useredit

  • Useredit_id (PK) — varchar(100) — Primary key — NOT NULL
  • User_Id (PK2) — varchar(100) — Foreign key → User.User_Id — NOT NULL