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)