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)
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