sample_app

Tables (3)

Untitled (comment)

  • 댓글아이디 (comment) — INT — Primary key — NOT NULL
  • 글아이디 (post_id) — INT — Foreign key → post.글아이디 — NOT NULL
  • 저자아이디 (author_id2) — INT — Foreign key — NOT NULL
  • 이름 (name2) — INT — Foreign key
  • 저자아이디 (author2) — INT — Foreign key → post.저자아이디 — NOT NULL
  • 저자아이디 (author3) — INT — Foreign key → author.저자아이디 — NOT NULL
  • 댓글본문 (contant) — TEXT
  • 댓글작성일 (CREATEaT) — timestamp

author

  • 저자아이디 (author) — INT — Primary key — NOT NULL
  • 이름 (name) — INT
  • 저자소개 (author_into) — vachar(100)
  • 가입일 (Field)

post

  • 글아이디 (post_id) — INT — Primary key — NOT NULL
  • 저자아이디 (author) — INT — Foreign key → author.저자아이디 — NOT NULL
  • 본문 (contans) — TEXT
  • 제목 (title) — varchar(100)
  • 작성일 (createAt) — timestamp