insta
Tables (9)
comment
- comment_id — BIGINT
- content — TEXT
- feed_id — BIGINT — NOT NULL
- writer_id — BIGINT — NOT NULL
- path — VARCHAR(255)
- status — ENUM('ACTIVE', 'DELETED_BY_USER', 'BLOCKED') — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
feed_images
- image_id — BIGINT
- feed_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
feed_like
- feed_like_id — BIGINT
- feed_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
feeds
- feed_id — BIGINT
- writer_id — BIGINT — NOT NULL
- content — TEXT
- status — ENUM('ACTIVE', 'USER_DELETED', 'ADMIN_REMOVED') — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
like_count
- feed_id — BIGINT
- like_count — BIGINT — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
reports
- report_id — BIGINT
- reporter_id — BIGINT — NOT NULL
- feed_id — BIGINT
- comment_id — BIGINT
- reason — VARCHAR(500) — NOT NULL
- status — ENUM('PENDING', 'BLOCK_COMPLETED', 'REJECTED') — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
subscriptions
- subscription_id — BIGINT
- follower_id — BIGINT — NOT NULL
- followee_id — BIGINT — NOT NULL
- start_at — TIMESTAMP(6) — NOT NULL
- end_at — TIMESTAMP(6)
- follow_status — ENUM('FOLLOWING', 'UNFOLLOWED', 'BLOCKED_BY_FOLLOWEE') — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
user_agreements
- agreement_id — BIGINT
- user_id — BIGINT — NOT NULL
- agreement_type — ENUM('DATA_POLICY', 'LOCATION_BASED_SERVICE', 'TERMS_OF_SERVICE') — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- agreed_at — TIMESTAMP(6)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
users
- user_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100)
- phone_number — VARCHAR(255)
- birth_day — DATE
- provider — ENUM('GOOGLE', 'KAKAO', 'NAVER')
- oauth_id — VARCHAR(255)
- role — ENUM('ADMIN', 'USER')
- status — ENUM('ACTIVE', 'INACTIVE', 'SUSPENDED') — NOT NULL
- last_login_at — TIMESTAMP(6)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL