레드박스 수정본

테이블 (9)

Articles

  • article_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → Users.user_id — NOT NULL
  • article_url — varchar
  • subject — varchar
  • source — varchar
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar

Notices

  • notice_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → Users.user_id — NOT NULL
  • notice_title — varchar
  • notice_content — text
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar
  • notice_hits — int

Redcards

  • redcard_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → Users.user_id — NOT NULL
  • donation_date — date
  • serial_number — varchar
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar
  • redcard_status — enum — ACTIVE(활성), USED(사용됨)
  • hospital_name — varchar

Requests

  • request_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → Users.user_id — NOT NULL
  • request_title — varchar
  • request_content — text
  • target_amount — int
  • current_amount — int
  • request_status — enum — request, progress, end
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar
  • donation_start_date — date
  • donation_end_date — date
  • priority — enum
  • request_hits — int

Transaction_Details

  • transaction_detail_id — bigint — 기본 키 — NOT NULL
  • transaction_group_id — bigint — 외래 키 → Transaction_Groups.transaction_group_id — NOT NULL
  • redcard_id — bigint — 외래 키 → Redcards.redcard_id — NOT NULL

Transaction_Groups

  • transaction_group_id — bigint — 기본 키 — NOT NULL
  • transaction_type — enum
  • request_id — bigint — 외래 키 → Requests.request_id — NOT NULL
  • from_type — enum
  • from_user_id — bigint — 외래 키 → Users.user_id — NOT NULL
  • to_type — enum
  • to_user_id — bigint — 외래 키 → Users.user_id — NOT NULL
  • amount — int
  • status — enum
  • message — varchar
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar

Users

  • user_id — bigint — 기본 키 — NOT NULL
  • email — varchar
  • password — varchar
  • name — varchar
  • birth — date
  • phone_number — varchar
  • road_address — varchar
  • extra_address — varchar
  • detail_address — varchar
  • gender — enum — MALE, FEMALE
  • grade — enum
  • role_type — enum — ADMIN, USER
  • status — enum — ACTIVE, INACTIVE
  • create_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar
  • last_login_at — datetime

attach_files

  • attach_file_id — bigint — 기본 키 — NOT NULL
  • category — enum
  • request_id — bigint — 외래 키 → Requests.request_id — NOT NULL
  • notice_id — bigint — 외래 키 → Notices.notice_id — NOT NULL
  • original_filename — varchar
  • new_filename — varchar
  • attach_file_type — varchar
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar

likes

  • like_id — bigint — 기본 키 — NOT NULL
  • request_id — bigint — 외래 키 → Requests.request_id — NOT NULL
  • user_id — bigint — 외래 키 → Users.user_id — NOT NULL