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