MoongCheap_erd_v1
Tables (9)
member
- id — BIGINT — Primary key — NOT NULL
- default_address_id — BIGINT — Foreign key → shipping_address.id
- login_id — VARCHAR(20)
- nickname — VARCHAR(20) — NOT NULL
- phone_number — BYTEA
- email — VARCHAR(255)
- is_seller — BOOLEAN — NOT NULL
- last_login_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
member_local
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- password — VARCHAR(255) — NOT NULL
- password_updated_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
member_notification_setting
- type — VARCHAR(40) — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- is_enabled — BOOLEAN — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
member_social
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
seller
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- business_name — VARCHAR(50) — NOT NULL
- business_number — BYTEA — NOT NULL
- business_number_hash — CHAR(64) — NOT NULL
- mail_order_registration_number — VARCHAR(30) — NOT NULL
- owner_name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- seller_status — VARCHAR(20) — NOT NULL
- approved_at — TIMESTAMPTZ
- bank_name — VARCHAR(50) — NOT NULL
- bank_account — BYTEA — NOT NULL
- depositor_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
seller_interest_category
- category_id — BIGINT — Primary key — NOT NULL
- seller_id — BIGINT — Foreign key → seller.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
shipping_address
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- alias — VARCHAR(30) — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- phone_number — BYTEA — NOT NULL
- zipcode — VARCHAR(5) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- address_detail — VARCHAR(100)
- request_message — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
terms
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(30) — NOT NULL
- version — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- is_required — BOOLEAN — NOT NULL
- effective_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
terms_agreement
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- terms_id — BIGINT — Foreign key → terms.id — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- agreed_at — TIMESTAMPTZ — NOT NULL