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