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