함께모으기_양동주연습
테이블 (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)