rewardService

Tables (10)

donation

  • donation_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • donation_current_amount — bigint
  • end_date — datetime(6)
  • start_date — datetime(6)
  • donation_target_amount — bigint
  • donation_title — varchar(255)

donation_record

  • id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • donation_points — bigint
  • donation_id — binary(16)
  • user_id — binary(16)

event

  • event_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • end_date — datetime(6)
  • start_date — datetime(6)
  • event_state — varchar(255)
  • event_type — enum
  • event_name — varchar(255)

event_participation

  • id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • description — varchar(255)
  • points — bigint
  • event_id — binary(16)
  • user_id — binary(16)

gift_record

  • id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • gift_message — varchar(255)
  • points_gifted — bigint
  • receiver_id — binary(16)
  • sender_id — binary(16)

point

  • point_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • activity_id — binary(16)
  • amount — bigint
  • deleted — char
  • description — varchar(255)
  • point_type — varchar(255)
  • user_id — binary(16)

product

  • product_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • product_category — varchar(255)
  • company_name — varchar(255)
  • product_description — varchar(255)
  • product_price — bigint
  • product_name — varchar(255)
  • product_stock — int
  • user_email — binary(16)

product_image

  • id — binary(16) — NOT NULL
  • image_url — varchar(255)
  • upload_image_name — varchar(255)
  • product_id — binary(16)

purchase_record

  • id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • points_used — bigint
  • product_id — binary(16)
  • user_id — binary(16)

user

  • id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • user_email — varchar(255)
  • member_state — enum
  • user_name — varchar(255)
  • user_nick_name — varchar(255)
  • user_password — varchar(255)
  • profile_image_url — varchar(255)
  • user_total_point — bigint
  • user_social — bit