copo

Tables (3)

COPO (copos)

  • Copo ID (copo_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → USER.User ID — NOT NULL
  • Title (title) — VARCHAR(255)
  • Principal (principal) — INT
  • Create At (create_at) — VARCHAR(20)
  • Update At (update_at) — VARCHAR(20)

COPO ITEM (copo_items)

  • Copo Item ID (copo_item_id) — INT — Primary key — NOT NULL
  • Copo ID (copo_id) — INT — Foreign key → COPO.Copo ID — NOT NULL
  • Stock Name (stock_name) — VARCHAR(255)
  • Percent (percent) — FLOAT
  • Field

USER (users)

  • User ID (user_id) — INT — Primary key — NOT NULL
  • Email (email) — VARCHAR(255)
  • Password (password) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Birthday (birthday) — VARCHAR(20)
  • Create At (create_at) — VARCHAR(20)
  • Update At (update_at) — VARCHAR(20)