[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