member_history
member_history_check-((claim_member_id IS NULL) <> (member_seen_id IS NULL))
access_user=>login.login_idclaim_member_id=>claim_member.claim_member_idmember_seen_id=>member_seen.member_seen_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
member_history_id | bigint | No | Yes | - Generated through expression: |
claim_member_id | bigint | Yes | No | - Generated through expression: |
member_seen_id | bigint | Yes | No | - Generated through expression: |
member_type | member_type | No | No | - Generated through expression:
CASE
WHEN (claim_member_id IS NOT NULL) THEN 'Claim'::claims.member_type
ELSE 'Eligibility'::claims.member_type
END |
access_user | bigint | No | No | - Generated through expression: |
access_time | timestamp with time zone | No | No | - Generated through expression: |
access_type | access_type | No | No | - Generated through expression: |