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