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