동네고영희
테이블 (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)