first
Tables (4)
Stock_user (Untitled2)
- index (Key3) — int(10) — Primary key — NOT NULL
- userid (Key) — char(20) — Primary key — NOT NULL
- ingredient (Key2) — char(30) — Primary key — NOT NULL
- Expiration_date (Field) — varchar(30)
- count (Field2) — int(4)
Untitled4
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
store (Untitled3)
- store_id (Key) — index — Primary key — NOT NULL
- address (Field) — varchar(30)
- phone (Field2) — char(20)
- store_name (Field3) — char(20)
- pw (Field4) — varchar(30)
- registraion_no (Field5) — char(20)
- store_email (Field6) — varchar(30)
user (Untitled)
- userid (Key) — char(20) — Primary key — NOT NULL — 로그인아이디
- store_id (Key2) — index — Primary key — NOT NULL
- health_name (Key3) — char(20) — Primary key — NOT NULL
- pw (Field) — varchar(20)
- name (Field2) — char(20)
- email (Field3) — varchar(30)
- phone (Field4) — char(20)
- address (Field5) — varchar(30)
- gender (Field6) — bit(1)