SSAFY 공통프로젝트

테이블 (9)

Code (Untitled8)

  • nickname (Field) — VARCHAR
  • code (Field2) — VARCHAR

Inventory (Untitled3)

  • id (Key) — INT — 기본 키 — NOT NULL
  • count (Field) — INT

Inventory (CopyOfUntitled2)

  • id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • info (Field2) — VARCHAR
  • price (Field3) — INT

Item (Untitled2)

  • id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • info (Field2) — VARCHAR
  • price (Field3) — INT

Problem (Untitled4)

  • id (Key) — INT — 기본 키 — NOT NULL
  • num (Field) — INT
  • content (Field2) — VARCHAR
  • difficulty (Field3) — INT
  • exp (Field4) — INT
  • coin (Field5) — INT

Problem_solved (Untitled5)

  • solved (Field) — BOOLEAN

Room (Untitled6)

  • id (Key) — INT — 기본 키 — NOT NULL
  • title (Field) — VARCHAR
  • type (Field2) — VARCHAR
  • password (Field3) — VARCHAR
  • problem_no (Field4) — INT
  • max_count (Field5) — INT
  • language (Field6) — VARCHAR
  • time_limit (Field7) — INT
  • review (Field8) — BOOLEAN
  • started (Field9) — BOOLEAN

Room_waiting (Untitled7)

  • nickname (Field) — VARCHAR
  • master (Field2) — VARCHAR
  • is_ready (Field3) — BOOLEAN

User (Untitled)

  • nickname (Key) — VARCHAR — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • email (Field2) — VARCHAR
  • sex (Field3) — VARCHAR
  • password (Field4) — VARCHAR
  • level (Field5) — INT
  • exp (Field6) — INT
  • coin (Field7) — INT
  • inventory (Key2) — INT — 외래 키 → Inventory.id — NOT NULL