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)