aa

Tables (5)

Bookmarks

  • BookmarksTable_PK (PK) — Long — Primary key — NOT NULL
  • UserTable PK (FK) — Long — Foreign key → Users.UserTable PK — NOT NULL
  • PostsTable_PK (PK3) — Long — Foreign key → Posts.PostsTable_PK — NOT NULL

Comments

  • CommentTable_PK (PK) — Long — Primary key — NOT NULL
  • UserTable PK (FK) — Long — Foreign key → Users.UserTable PK — NOT NULL
  • PostsTable_PK (post_id) — Long — Foreign key → Posts.PostsTable_PK — NOT NULL
  • 댓글내용 — String
  • 댓글작성시간 — DATE — NOT NULL
  • 댓글수정시간 — DATE

ImageFiles

  • ImageFiles (PK) — Long — Primary key — NOT NULL
  • PostsTable_PK (FK) — Long — Foreign key → Posts.PostsTable_PK — NOT NULL
  • 파일이름 — String
  • 파일경로 — String
  • 파일크기 — Long

Posts

  • PostsTable_PK (PK) — Long — Primary key — NOT NULL
  • UserTable PK (FK) — Long — Foreign key → Users.UserTable PK — NOT NULL
  • 글제목 — String
  • 글내용 — String
  • image (image_url) — String
  • 글 생성날짜 (create_at) — DATE
  • 글 수정날짜 (modifide_at) — DATE

Users

  • UserTable PK (PK) — Long — Primary key — NOT NULL
  • User_id (유저 아이디) — String
  • Nick_name (유저 닉네임) — String
  • Password (비밀번호) — String