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