naegginiggi
Tables (7)
Campaign
- campaign_id — Integer — Primary key — NOT NULL
- rdonaBoxNo (캠페인 고유번호) — String
- title (캠페인 제목) — String
- image (대표 이미지) — Image
- summary (줄거리) — Text
- hlogName (재단 이름) — String
- startYmd (캠페인 시작일) — DateTime
- endYmd (캠페인 마감일) — DateTime
- currnetAmount (현재 기부 금액) — Integer
- donationCount (기부 건 수) — Integer
- goalAmount (목표 기부 금액) — Integer
Donation_Point
- Key (Donation_History_id) — Integer — Primary key — NOT NULL
- user_id — Integer — Foreign key → User.user_id — NOT NULL
- Field (point) — Integer
- Field (expiry_date) — DateTime
- Field (description) — Text
- Field (created_at) — DateTime
Record
- Key (record_id) — Integer — Primary key — NOT NULL
- Key (user_day_record_id) — Integer — Foreign key → User_Record.Key — NOT NULL
- Field (when) — String
- Field (category) — String
- Field (price) — Integer
- Field (memo) — Text
- Field (settlement) — Bool
User
- user_id — Integer — Primary key — NOT NULL
- userid (사용자 아이디) — String
- password — String
- email — String
- username (닉네임) — String
User_Campaign
- user_id — Integer — Foreign key → User.user_id — NOT NULL
- campaign_id — Integer — Foreign key → Campaign.campaign_id — NOT NULL
User_Custom
- user_id — Integer — Foreign key → User.user_id — NOT NULL
- month_budget (한 달 예산) — Integer
- donation_temperature (기부 온도) — Float
- total_donation (총 기부금액) — Integer
- donation_count (기부 횟수) — Integer
User_Record
- Key (user_day_record_id) — Integer — Primary key — NOT NULL
- user_id — Integer — Foreign key → User.user_id — NOT NULL
- Field (day_budget) — Integer
- Field (today_date) — DateTime
- Field (consumption) — Integer
- Field (donation) — Integer