미니프로젝트

테이블 (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