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