함께모으기_양동주연습

테이블 (9)

account transaction (Untitled2)

  • transaction_id — VARCHAR(255) — 기본 키 — NOT NULL
  • account_number — VARCHAR(255) — 외래 키 → accounts.account_number — NOT NULL
  • transaction_amount — VARCHAR(255)
  • trasaction_result_amount — VARCHAR(255)

accounts

  • account_number — VARCHAR(255) — 기본 키 — NOT NULL
  • remain_amount — VARCHAR(255)

challenge

  • challenge_name — VARCHAR(255) — 기본 키 — NOT NULL
  • start_date — VARCHAR(255) — NOT NULL
  • end_date — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • goal_amount — VARCHAR(255)
  • penalty_amount — VARCHAR(255)
  • is_official — VARCHAR(255)
  • mode — VARCHAR(255)
  • is_active — VARCHAR(255)
  • frequency

challenge account (Untitled3)

  • challenge_name — VARCHAR(255) — 외래 키 → challenge.challenge_name — NOT NULL
  • account_number — VARCHAR(255) — 외래 키 → accounts.account_number — NOT NULL
  • email — VARCHAR(255) — 외래 키 → users.email — NOT NULL

challenge participation

  • participation_id — VARCHAR(255) — 기본 키 — NOT NULL
  • challenge_name — VARCHAR(255) — 외래 키 → challenge.challenge_name — NOT NULL
  • email — VARCHAR(255) — 외래 키 → users.email — NOT NULL
  • role — VARCHAR(255)

review

  • review_id — VARCHAR(255) — 기본 키 — NOT NULL
  • challenge_name — VARCHAR(255) — 외래 키 → challenge.challenge_name — NOT NULL
  • email — VARCHAR(255) — 외래 키 → users.email — NOT NULL
  • content — VARCHAR(255)
  • created_at — VARCHAR(255)

tag

  • tag_id — VARCHAR(255) — 기본 키 — NOT NULL
  • challenge_name — VARCHAR(255) — 외래 키 → challenge.challenge_name — NOT NULL
  • content — VARCHAR(255)

user account (Untitled)

  • email — VARCHAR(255) — 외래 키 → users.email — NOT NULL
  • account_number — VARCHAR(255) — 외래 키 → accounts.account_number — NOT NULL

users

  • email — VARCHAR(255) — 기본 키 — NOT NULL
  • nickname — VARCHAR(255)
  • name — VARCHAR(255)
  • gender — VARCHAR(255)
  • password — VARCHAR(255)
  • is_official — VARCHAR(255)
  • birth_year — VARCHAR(255)
  • birth_month — VARCHAR(255)
  • birth_day — VARCHAR(255)