DjangoErpProject

Tables (5)

accounts (account)

  • name (user_name) — string — Primary key — NOT NULL
  • email (user_email) — email — Primary key — NOT NULL
  • password (user_pw) — password

inbound (Untitled2)

  • code (inbound_code) — string — Primary key — NOT NULL
  • quantity (inbound_quantity) — int
  • date (inbound_date) — date
  • price (inbound_price) — int

inventory (Untitled4)

  • code (inventory_code) — string — Primary key — NOT NULL
  • quantity (inventory_quantity) — int — Primary key — NOT NULL

outbound (Untitled3)

  • code (outbound_code) — string — Primary key — NOT NULL
  • quantity (outbound_quantity) — int
  • date (outbound_date) — date
  • price (outbound_price) — int

products (Untitled)

  • code (product_code) — string — Primary key — NOT NULL
  • name (product_name) — string
  • description (product_description) — string
  • price (product_price) — int
  • size (product_size) — char