test
Tables (9)
ask (Untitled7)
- ask_id (Key) — char — Primary key — NOT NULL
- user_id (Key2) — char — Foreign key → user.회원아이디 — NOT NULL
- content (Field3) — string
calender (Untitled8)
- calender_id — char — Primary key — NOT NULL
- dog_id — Foreign key → pet.dog_id — NOT NULL
- 시간 (date) — date
- 알림설정 (notification) — boolean
- 메모 (memo) — string
- 백신 (vaccination) — varchar
comment (Untitled5)
- 댓글아이디 (comment_id) — char — Primary key — NOT NULL
- date (Field) — timestamp
- post_id (Key) — char — Foreign key → post.post_id — NOT NULL
- 회원아이디 (user_id) — char(10) — Foreign key → user.회원아이디 — NOT NULL
like (Untitled9)
- post_id — char — Foreign key → post.post_id — NOT NULL
pet (Untitled2)
- dog_id — Primary key — NOT NULL
- user_id — Foreign key → user.회원아이디 — NOT NULL
- name
- gender
- birth (birthday)
- breed
- meeting_path
post (Untitled3)
- post_id — char — Primary key — NOT NULL
- user_id — char — Foreign key → user.회원아이디 — NOT NULL
- title — varchar
- content — string
- date — date
- like — int
- img — varchar?
re_comment (Untitled6)
- re_comment_id (recomment_id) — string — Primary key
- 댓글아이디 (comment_id) — Foreign key → comment.댓글아이디 — NOT NULL
- 회원아이디 (user_id) — char(10) — Foreign key → user.회원아이디 — NOT NULL
review (Untitled4)
- reiew_id (Key) — Primary key — NOT NULL
- user_id (Key2) — char — Foreign key → user.회원아이디 — NOT NULL
- content (Field) — string
user (Untitled)
- 회원아이디 (user_id) — char(10) — Primary key — NOT NULL
- 이름 (name) — varchar
- 나이 (age) — int
- 등록일 (regist_date) — timestamp
- 생일 (birth) — date