[TEAM_ACE]_Image_Analysis
Tables (6)
comments
- comment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- content — TEXT
- create_at — TIMESTAMP
likes
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- like_at — TIMESTAMP
posts
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- image_url — VARCHAR(255)
- content — TEXT
- create_at — TIMESTAMP
- update_at — TIMESTAMP
- delete_at — TIMESTAMP
tags
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- content — VARCHAR(255)
users
- user_id — BIGINT — Primary key — NOT NULL
- user_name — VARCHAR(255)
- verified — TINYINT(1)
- create_at — TIMESTAMP
views
- view_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- view_at — TIMESTAMP