Livingnews
Tables (4)
agendas (案件)
- id (primary) — bigint — Primary key — NOT NULL
- user_id (foreign1) — tinyInteger — Foreign key → users.id — ユーザー名
- department_id (primary2) — bigint — Foreign key → departments.id — 部署名
- customer_id (foreign3) — bigint — Foreign key → customers.id — 顧客名
- customer_manager (index1) — varchar(200) — 顧客担当者
- date (Field3) — timestamp — 日付
- price (Field5) — bigint — 価格
- product (index2) — varchar(200) — 商品
- amount (Field6) — bigint — 数量
- note (Field7) — varchar(200) — 備考
- created_at (Field2) — timestamp
- updated_at (Field4) — timestamp
customers (顧客マスター)
- id (primary) — bigint — Primary key — NOT NULL
- name (Field) — varchar(200) — NOT NULL — 顧客名
- created_at (Field2) — timestamp
- updated_at (Field4) — timestamp
departments (部署)
- id (primary) — bigint — Primary key — NOT NULL
- name (Field) — varchar(200) — NOT NULL — 部署名
- created_at (Field2) — timestamp
- updated_at (Field3) — timestamp
users (先方)
- id (primary) — bigint — Primary key — NOT NULL
- is_admin (Field5) — tinynt — NOT NULL — 0 =一般社員 1 =部署マスター
- account (unique) — varchar(200) — NOT NULL — ログイン用アカウント
- password (Field3) — varchar(200) — NOT NULL
- created_at (Field2) — timestamp
- updated_at (Field4) — timestamp