MOA gift funding

Tables (16)

announcement

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • title — VARCHAR(255)
  • content — VARCHAR(255)

delivery_address

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • member_id — BIGINT — Foreign key → member.id
  • is_default — BIT(1)
  • zonecode — VARCHAR
  • road_address — VARCHAR
  • jibun_address — VARCHAR
  • detail_address — VARCHAR
  • name — VARCHAR
  • recipient_name — VARCHAR
  • phone_number — VARCHAR

faq

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • category — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255)
  • answer — VARCHAR(255)

friend

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • member_id — BIGINT — Foreign key → member.id
  • target_id — BIGINT — Foreign key → member.id
  • nickname — VARCHAR(255) — NOT NULL
  • is_blocked — BIT(1)

funding

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • image_url — VARCHAR(255)
  • title — VARCHAR(25)
  • description — VARCHAR(255)
  • end_date — date
  • visible — VARCHAR(255)
  • status — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id
  • product_id — BIGINT — Foreign key → product.id
  • delivery_request_message — VARCHAR(255)
  • maximum_amount — DECIMAL
  • minimum_amount — DECIMAL
  • zonecode — VARCHAR
  • road_address — VARCHAR
  • jibun_address — VARCHAR
  • detail_address — VARCHAR
  • name — VARCHAR
  • recipient_name — VARCHAR
  • phone_number — VARCHAR
  • my_finished_payment_amount — DECIMAL

funding_message

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • member_from_id — BIGINT — Foreign key → member.id
  • member_to_id — BIGINT — Foreign key → member.id
  • content — VARCHAR(255)
  • visible — VARCHAR(255)

funding_participant

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • member_id — BIGINT — Foreign key → member.id
  • funding_id — BIGINT — Foreign key → funding.id
  • payment_id — BIGINT — Foreign key → toss_payment.id
  • funding_message_id — BIGINT — Foreign key → funding_message.id — NOT NULL
  • status — VARCHAR(255)
  • amount — DECIMAL

member

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • birthyear — VARCHAR(255)
  • birthday — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • status — VARCHAR(255)
  • toss_customer_key — VARCHAR(255)
  • oauth_id — VARCHAR(255) — NOT NULL
  • oauth_provider — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(255)
  • verified_phone — BIT(1)
  • device_token — VARCHAR(255)

notification

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • url — VARCHAR(255)
  • title — VARCHAR(255)
  • message — VARCHAR(255)
  • image_url — VARCHAR(255)
  • type — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id
  • is_read — BIT(1) — NOT NULL

orders

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • funding_id — BIGINT — Foreign key → funding.id
  • product_id — BIGINT — Foreign key → product.id
  • delivery_request_message — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id
  • status — VARCHAR(255)
  • possible_reissue_coupon_count — INT — NOT NULL
  • zonecode — VARCHAR
  • road_address — VARCHAR
  • jibun_address — VARCHAR
  • detail_address — VARCHAR
  • name — VARCHAR
  • recipient_name — VARCHAR
  • phone_number — VARCHAR

personal_inquiry

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • category — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id
  • answer — VARCHAR(255)

product

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • image_url — VARCHAR(255)
  • brand — VARCHAR(255)
  • category — VARCHAR(255)
  • product_name — VARCHAR(255)
  • description — VARCHAR(255)
  • sale_end_date — date
  • discount_rate — INT — NOT NULL
  • limit_date — INT — NOT NULL
  • status — VARCHAR(255)
  • product_id — VARCHAR(255) — NOT NULL
  • product_provider — VARCHAR(255) — NOT NULL
  • price — DECIMAL

product_option

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • option_name — VARCHAR(255)
  • code — VARCHAR(255) — NOT NULL
  • product_id — BIGINT — Foreign key → product.id
  • status — VARCHAR(255)

report

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • domain — VARCHAR(255)
  • domain_id — BIGINT
  • content — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id
  • done — BIT(1) — NOT NULL

sms_history

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • message — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • error_message — VARCHAR(255)
  • status — SMALLINT

toss_payment

  • id — BIGINT — Primary key — NOT NULL
  • created_date — datetime
  • updated_date — datetime
  • payment_key — VARCHAR(255) — NOT NULL
  • order_id — VARCHAR(255) — NOT NULL
  • order_name — VARCHAR(255)
  • member_id — BIGINT
  • status — VARCHAR(255)
  • total_amount — DECIMAL
  • idempotency_key — VARCHAR(255)
  • reason — VARCHAR(255)
  • id_key_updated_date — datetime