tripodlab_stock_management

Tables (4)

EmailCode

  • id — Integer — Primary key — NOT NULL
  • email — String(120) — NOT NULL
  • code — String(120) — NOT NULL
  • date_time — DateTime
  • reserved1 — String(120)
  • reserved2 — String(120)
  • reserved3 — String(120)
  • reserved4 — String(120)
  • reserved5 — String(120)

Item

  • id — integer — Primary key — NOT NULL
  • user_id (id2) — integer — Foreign key → User.id — NOT NULL
  • item_name — String(120) — NOT NULL
  • unit — String(120) — NOT NULL
  • note — Text
  • start_date — DateTime
  • end_date — DateTime
  • active — String(120) — NOT NULL
  • created — DateTime
  • reserved1 (reserved) — String(120)
  • reserved2 — String(120)
  • reserved3 — String(120)
  • reserved4 — String(120)
  • reserved5 — String(120)

Stock

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → User.id — NOT NULL
  • item_id — integer — Foreign key → Item.id — NOT NULL
  • item_name — String(120) — NOT NULL
  • unit — String(120) — NOT NULL
  • previous_stock — Integer — NOT NULL
  • purchase — Integer — NOT NULL
  • usage — Integer — NOT NULL
  • loss — Integer — NOT NULL
  • current_stock — Integer — NOT NULL
  • active — String(120) — NOT NULL
  • note — Text
  • stock_date — DateTime
  • created — DateTime
  • reserved1 (reserved) — String(120)
  • reserved2 — String(120)
  • reserved3 — String(120)
  • reserved4 — String(120)
  • reserved5 — String(120)

User

  • id — integer — Primary key — NOT NULL
  • user_id — String(120) — NOT NULL
  • password — String(120) — NOT NULL
  • user_name — String(120) — NOT NULL
  • company — String(120) — NOT NULL
  • contact — String(120) — NOT NULL
  • email — String(120) — NOT NULL
  • address — String(120)
  • address_detail — String(120)
  • post_no — String(120)
  • note — Text
  • created — DateTime
  • reserved1 (reserved) — String(120)
  • reserved2 — String(120)
  • reserved3 — String(120)
  • reserved4 — String(120)
  • reserved5 — String(120)