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)