mini_project

Tables (5)

comments

  • id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feeds.id
  • user_id — BIGINT — Foreign key → users.id
  • content — VARCHAR(255)
  • status — ENUM('ACTIVE','INACTIVE','PENDING')
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

feed_images

  • id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feeds.id
  • image_extension — VARCHAR(255)
  • original_image_name — VARCHAR(255)
  • stored_image_name — VARCHAR(255)

feed_views

  • id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feeds.id
  • user_id — BIGINT — Foreign key → users.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

feeds

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • content — TEXT
  • status — ENUM('ACTIVE','INACTIVE','PENDING')
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • nick_name — VARCHAR(255)
  • password — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • user_name — VARCHAR(255)
  • batch — ENUM('EIGHTH','FIFTH','FIRST','FOURTH','NINTH','SECOND','SEVENTH','SIXTH','TENTH','THIRD')
  • mode — ENUM('OFFLINE','ONLINE')
  • role — ENUM('ROLE_ADMIN','ROLE_USER')
  • status — ENUM('ACTIVE','INACTIVE','PENDING')
  • track — ENUM('BACKEND','FRONTEND')
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)