pill

Tables (3)

PILL

  • itemSeq — bigint — Primary key
  • entpName — varchar(1000)
  • itemName — varchar(1000)
  • useMethodQesitm — varchar(3000)
  • itemImage — varchar(1000)
  • efcyQesitm — varchar(3000)
  • atpnWarnQesitm — varchar(3000)
  • atpnQesitm — varchar(3000)
  • intrcQesitm — varchar(3000)
  • seQesitm — varchar(3000)
  • depositMethodQesitm — varchar(3000)

bookmark (Untitled2)

  • id (Key) — varchar(1000) — Foreign key → user.id — NOT NULL
  • itemSeq — bigint — Foreign key → PILL.itemSeq

user (Untitled)

  • id (Key) — varchar(1000) — Primary key — NOT NULL
  • pwd (Field) — varchar(1000)
  • name (Field2) — varchar(1000)
  • phone (Field3) — varchar(1000)
  • email (Field4) — varchar(1000)
  • addr (Field5) — varchar(1000)