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