전장의안개

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

Untitled5

    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