mystagram
Tables (8)
ChatMessage (CHAT_MESSAGE)
- id — BIGINT — Primary key — NOT NULL
- chatUserId (chat_user_id) — BIGINT — Foreign key → ChatUser.id — NOT NULL
- content — VARCHAR — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL
ChatRoom (CHAT_ROOM)
- id — BIGINT — Primary key — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL
ChatUser (CHAT_USER)
- id — BIGINT — Primary key — NOT NULL
- memberId (member_id) — BIGINT — Foreign key → Member.id
- chatRommId (chat_room_id) — BIGINT — Foreign key → ChatRoom.id — NOT NULL
Comment (COMMENT)
- id — BIGINT — Primary key — NOT NULL
- writerId (writer_id) — BIGINT — Foreign key → Member.id — NOT NULL
- postId (post_id) — BIGINT — Foreign key → Post.id
- content — VARCHAR — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL
Follow (FOLLOW)
- id — BIGINT — Primary key — NOT NULL
- followerId (follower_id) — BIGINT — Foreign key → Member.id — NOT NULL
- followingId (following_id) — BIGINT — Foreign key → Member.id — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL
Member (MEMBER)
- id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR — NOT NULL
- password — CHAR — NOT NULL
- profileImageUrl (profile_image_url) — VARCHAR
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL
Post (POST)
- id — BIGINT — Primary key — NOT NULL
- writerId (writer_id) — BIGINT — Foreign key → Member.id — NOT NULL
- imageUrl (image_url) — VARCHAR — NOT NULL
- content — VARCHAR
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL
Reply (REPLY)
- id — BIGINT — Primary key — NOT NULL
- writerId (writer_id) — BIGINT — Foreign key → Member.id — NOT NULL
- commentId (comment_id) — BIGINT — Foreign key → Comment.id
- content — VARCHAR — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL