userTest

Tables (3)

Comment (CopyOfUntitled2)

  • commentId — BIGINT — Primary key — NOT NULL — Auto increament
  • 댓글 내용 (content) — VARCHAR(300) — NOT NULL
  • 생성일자 (createAt) — TIMESTAMP — NOT NULL
  • 업데이트 일자 (updateAt) — TIMESTAMP — NOT NULL
  • status — BIT — NOT NULL
  • memberId — BIGINT — Foreign key → Member.memberId — NOT NULL — Auto increament
  • postId — BIGINT — Foreign key → Post.postId — NOT NULL — Auto increament

Member (Untitled)

  • memberId — BIGINT — Primary key — NOT NULL — Auto increament
  • 이름 (name) — VARCHAR(40) — NOT NULL
  • 전화번호 (phoneNum) — VARCHAR(40) — NOT NULL
  • status — BIT — NOT NULL

Post (Untitled2)

  • postId — BIGINT — Primary key — NOT NULL — Auto increament
  • 제목 (title) — VARCHAR — NOT NULL
  • 게시물 내용 (content) — VARCHAR(1000) — NOT NULL
  • 게시물 사진1 (picture1) — TEXT
  • 게시물 사진2 (picture2) — TEXT
  • 생성일자 (createAt) — TIMESTAMP — NOT NULL
  • 업데이트 일자 (updateAt) — TIMESTAMP — NOT NULL
  • status — BIT — NOT NULL