InnovationCamp
Tables (4)
COMMENT
- Comment Key (comment_key) — long — Primary key — NOT NULL
- Post Key (post_key) — long — Foreign key → POST.Post Key — NOT NULL
- User Key (user_key) — long — Foreign key → USER.User Key — NOT NULL
- Post Comment (post_comment) — longtext
POST
- Post Key (post_key) — long — Primary key — NOT NULL
- User Key (user_key) — long — Foreign key → USER.User Key — NOT NULL
- Created At (created_at) — datetime
- Modified At (modified_at) — datetime
- Title (title) — Text
- Like Count (like_count) — BIGINT(20)
- Comment Count (comment_count) — BIGINT(20)
- Image URL (image_url) — VARCHAR(255)
- Content (content) — longtext
SUBCOMMENT
- Subcomment Key (subcomment_key) — long — Primary key — NOT NULL
- User Key (user_key) — long — Foreign key → USER.User Key — NOT NULL
- Comment Key (comment_key2) — long — Foreign key → COMMENT.Comment Key — NOT NULL
- Post Key (post_key) — long — Foreign key → COMMENT.Post Key — NOT NULL
- Subcomment (subcomment) — longtext
USER
- User Key (user_key) — long — Primary key — NOT NULL
- User Name (user_name) — String
- User Id (user_id) — VARCHAR(60)
- User Password (user_password) — VARCHAR(64)