Gift-Moment

Tables (6)

gift

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • image — VARCHAR(255) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • link — VARCHAR(255)
  • description — TEXT
  • target_amount — DECIMAL(10, 0) — NOT NULL
  • current_amount — DECIMAL(10, 0)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

letters

  • id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • receiver_id — BIGINT — Foreign key → members.id — NOT NULL
  • sender_id — BIGINT — Foreign key → members.id — NOT NULL

member_accounts

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • bank_code — VARCHAR(10) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • account_holder — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

members

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

notifications

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • notification_type — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

payments

  • id — BIGINT — Primary key — NOT NULL
  • gift_id — BIGINT — Foreign key → gift.id — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_type — VARCHAR(20) — NOT NULL
  • payment_status — VARCHAR(20) — NOT NULL
  • tid — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP