오늘의집

테이블 (11)

Untitled (product)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Key (managed_user_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (category_id) — varchar(255) — NOT NULL
  • Field (url) — archer(255) — NOT NULL
  • Key (picture_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (picture)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Field (picture) — archer(20) — NOT NULL
  • Field (picture_type) — int(11) — NOT NULL
  • Field (noti_position) — varchar(10) — NOT NULL

Untitled (category)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Key (picture_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (category_1) — varchar(255) — NOT NULL
  • Field (category_2) — archer(255) — NOT NULL

Untitled (user_role)

  • (user_id\) — bigint(20) — 외래 키 → user.user_id — NOT NULL
  • Key (role_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (role)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Field (authority) — archer(20) — NOT NULL
  • Field

Untitled (style)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Key (picture_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (css_name) — varchar(20) — NOT NULL

Untitled (managed_user)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • (user_id) — bigint(20) — 외래 키 → user.user_id — NOT NULL

Untitled (like)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Key (picture_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (like) — bit(1) — NOT NULL

Untitled (comment)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Key (picture_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (user_id) — bigint(20) — NOT NULL
  • Field (content) — varchar(255) — NOT NULL

oauthid

  • (id) — bigint(20) — 기본 키 — NOT NULL
  • (user_id) — bigint(20) — 외래 키 → user.user_id — NOT NULL
  • Field (access_token) — archer(255) — NOT NULL
  • Field (provider) — varchar(255) — NOT NULL

user

  • (user_id) — bigint(20) — 기본 키 — NOT NULL
  • (password) — archer(255) — NOT NULL
  • Field (account_expired) — bit(1) — NOT NULL