point
Tables (8)
order (orders)
- order_key (Key) — varchar2 — Primary key — NOT NULL
- order_status (Field) — varchar2 — NOT NULL
point_event
- point_event_key (Key) — number — Primary key — NOT NULL
- point_info_key (Key2) — number — Foreign key → user_point_info.point_info_key — NOT NULL
- event_type (Field2) — varchar2
- create_dt (Field3) — timestamp
point_item (point_Item)
- point_item_key (Key) — number — Primary key — NOT NULL
- point_info_key (Key2) — number — Foreign key → user_point_info.point_info_key — NOT NULL
- point_event_key (Key3) — number — Foreign key → point_event.point_event_key — NOT NULL
- point_amount (Field) — number
- point_type (Field2) — varchar2
- manual_flag (Field3) — boolean
- point_expiration_dt (Field4) — timestamp
- point_status (Field5) — varchar2
- create_dt (Field6) — timestamp
point_policy
- policy_key (Key) — number — Primary key — NOT NULL
- point_info_key (Key2) — number — Foreign key → user_point_info.point_info_key — NOT NULL
- point_earn_limit (Field) — number
- point_total_limit (Field2) — number
- create_dt (Filed3) — timestamp — NOT NULL
point_usage
- point_usage_key (Key) — number — Primary key — NOT NULL
- order_key (Key3) — varchar2 — Foreign key → order.order_key — NOT NULL
- point_event_key (Key2) — number — Foreign key → point_event.point_event_key — NOT NULL
- point_usage_amount (Field2) — number
- point_usage_type (Field3) — varchar2
- create_dt (Field) — timestamp
point_usage_link
- point_usage_link_key (Key) — number — Primary key — NOT NULL
- point_usage_key (Key2) — number — Foreign key → point_usage.point_usage_key — NOT NULL
- point_item_key (Key3) — number — Foreign key → point_item.point_item_key — NOT NULL
- point_event_key (Key22) — number — Foreign key → point_usage.point_event_key — NOT NULL
- point_usage_amount (Field) — number
- create_dt (Field2) — timestamp
user (users)
- user_id (Key) — varchar2 — Primary key — NOT NULL
user_point_info
- point_info_key (Key) — number — Primary key — NOT NULL
- user_id (Key2) — varchar2 — Foreign key → user.user_id — NOT NULL
- version (Field3) — varchar2
- point_total_balance (Field5) — number
- create_dt (Field4) — timestamp