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