raff

Tables (7)

account

  • id — bigint
  • email — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)
  • role — varchar(255)

account_address

  • id — bigint
  • address — varchar(255)
  • zip_code — varchar(255)
  • name — varchar(255)
  • account_id — bigint

raffle_item

  • id — bigint
  • description — varchar(255)
  • draw_date — datetime(6)
  • end_date — datetime(6)
  • name — varchar(255)
  • original_price — bigint
  • payment_due_date — datetime(6)
  • raffle_price — bigint
  • start_date — datetime(6)

raffle_item_option

  • id — bigint
  • option_name — varchar(255)
  • selected_count — bigint
  • raffle_item_id — bigint

raffle_participant

  • id — bigint
  • login_weight — bigint
  • order_weight — bigint
  • account_id — bigint
  • raffle_quantity_id — bigint

time_deal_item

  • id — bigint
  • deal_end_time — datetime(6)
  • deal_start_time — datetime(6)
  • description — varchar(255)
  • discount_price — bigint
  • name — varchar(255)
  • original_price — bigint

time_deal_item_option

  • id — bigint
  • add_amount — bigint
  • option_name — varchar(255)
  • quantity — bigint
  • item_id — bigint