CRM

Tables (4)

1 (opportunity)

  • 식별자 (id) — bigserial — Primary key — NOT NULL
  • Opportunity ID (opportunity_id) — varchar — NOT NULL
  • 거래처 (client_name) — varchar — NOT NULL
  • 산업 (industry) — varchar
  • 제목 (title) — varchar — NOT NULL
  • Key (probability_cd) — int — Foreign key — NOT NULL
  • 예상 매출 (expected_amt) — int8
  • 예상 종료 날짜 (expected_end_dt) — timestamp
  • Key (state_cd) — varchar — Foreign key → Untitled.Key
  • Key (client_cd) — varchar — Foreign key
  • Key (solution_cd) — varchar — Foreign key
  • Key (opportunity_cd) — varchar — Foreign key
  • Key (division_cd) — varchar — Foreign key
  • Key (member_id) — int8 — Foreign key → Untitled.Key — NOT NULL
  • 생성 날짜 (created_dt) — timestamp — NOT NULL
  • Field (modified_dt) — timestamp — NOT NULL
  • 제품군 (product) — varchar
  • Field (yearOfEnd) — int
  • Field (quarterOfEnd) — int

Untitled (code)

  • Key (cd_key) — varchar — Primary key — NOT NULL
  • Field2 (cd_nm) — varchar
  • Field (cd_desc) — varchar
  • Field (visible) — boolean
  • Field (grp_key) — varchar — Foreign key → Untitled.Field

Untitled (group)

  • Field (grp_key) — varchar — Primary key — NOT NULL
  • Field2 (grp_nm) — varchar
  • Field3 (grp_desc) — varchar
  • Field4 (visible) — boolean

Untitled (member)

  • Key (id) — bigserial — Primary key — NOT NULL
  • Field (name) — varchar
  • Field2 (email) — varchar
  • Field3 (password) — varchar
  • Field4 (role) — varchar
  • Field (created_dt) — timestamp
  • Field2 (modified_dt) — timestamp