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