동네고영희

테이블 (4)

cat (고양이)

  • Key (cat_idx) — Long — 기본 키 — NOT NULL
  • (size) — int
  • (color) — int
  • (ear) — int
  • (tail) — int
  • (whisker) — int
  • (name) — varchar(100)
  • (sido) — varchar(255)
  • (gugun) — varchar(255)
  • (often_seen) — varchar(255)
  • (sex) — varchar(100)
  • (age) — varchar(100)
  • (note) — varchar(100)
  • (tnr) — varchar(100)
  • (feed) — varchar(100)
  • (is_photo) — boolean
  • (createdTime) — LocalDateTime
  • (modifiedTime) — LocalDateTime
  • Key (user_idx) — Long — 외래 키 → user.Key — NOT NULL

image (사진)

  • Key (photo_idx) — Long — 기본 키 — NOT NULL
  • (url) — varchar(500)
  • Key (cat_idx) — Long — 외래 키 → cat.Key — NOT NULL

post (게시물)

  • Key (post_idx) — Long — 기본 키 — NOT NULL
  • (content) — varchar(255)
  • (createdTime) — LocalDateTime
  • (modifiedTime) — LocalDateTime
  • Key (cat_idx) — Long — 외래 키 → cat.Key — NOT NULL
  • Key (user_idx) — Long — 외래 키 → user.Key — NOT NULL

user (사용자)

  • Key (user_idx) — Long — 기본 키 — NOT NULL
  • (email)
  • (password)
  • (nickname) — varchar(100)
  • (sido) — varchar(255)
  • (gugun) — varchar(255)
  • (login_type) — varchar(100)