전장의안개
테이블 (5)
Category
- id (Key) — int — 기본 키 — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- Field2
Place
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- description (Field3) — varchar(250) — NOT NULL
- lat (Field4) — DECIMAL — NOT NULL
- lng (Field6) — DECIMAL — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field5) — timestamp — NOT NULL
- marker_url (Field7) — varchar(250) — NOT NULL
- address (Field9) — varchar(250) — NOT NULL
- category (filed) — int — 외래 키 → Category.id — NOT NULL — 카테고리 외래키
- score (Field8) — int — NOT NULL
Rank
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- condition (Field2) — int — NOT NULL
- badge_url (Field3) — varchar(250) — NOT NULL
User
- id (Key) — bigint — 기본 키 — NOT NULL
- badge (Key2) — 기본 키 — NOT NULL
- oauth_id (Field) — bigint — NOT NULL
- nickname (Field2) — varchar(20) — NOT NULL
- profile_url (Field3) — varchar(250) — NOT NULL
- level (Field9)
- prestige (Field4) — int — NOT NULL
- isAdmin (Field7) — varchar(20) — NOT NULL
- created_at (Field5) — timestamp — NOT NULL
- updated_at (Field6) — timestamp