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