레드박스 수정본
테이블 (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