미니프로젝트
테이블 (4)
account (Untitled)
- account_id (PK) — VARCHAR(20) — 기본 키 — NOT NULL
- user_number (FK) — INT — 외래 키 → user.user_number — NOT NULL
- cash (Field5) — FLOAT
- bank (Field6) — VARCHAR(20)
- LINK (Field) — VARCHAR(20)
coin (Untitled4)
- coin_id (PK) — INT — 기본 키 — NOT NULL
user (Untitled2)
- user_number (PK) — INT — 기본 키 — NOT NULL
- user_id (Field) — VARCHAR(20)
- user_name (Field2) — VARCHAR(20)
- email (Field3) — VARCHAR(30)
- phone (Field4) — VARCHAR(15)
- gender (Field5) — CHAR(1)
- age (Field6) — TINYINT
wallet (Untitled3)
- user_number — INT — 외래 키 → user.user_number — NOT NULL
- coin_id (Key) — INT — 외래 키 → coin.coin_id — NOT NULL
- Field
- Field2