brs-gridge-test-server

Tables (14)

Attachment

  • attachment_id — INT — Primary key
  • post_id (post_id2) — INT — Foreign key → Post.post_id
  • file_type — ENUM('IMAGE','VIDEO','ETC')
  • file_url — VARCHAR(255)

Comment (comments)

  • comment_id — INT — Primary key
  • post_id — INT — Foreign key → Post.post_id
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • content — TEXT — NOT NULL
  • status (Field) — ENUM('ACTIVE','DELETED')
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Follow (follows)

  • id (Key) — INT — Primary key — NOT NULL
  • follower_id (user_id) — INT — Foreign key → User.user_id
  • followee_id (user_id2) — INT — Foreign key → User.user_id
  • created_at — TIMESTAMP — NOT NULL

Log

  • log_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • entity_type — VARCHAR(50)
  • entity_id — INT
  • action — VARCHAR(50)
  • message — TEXT
  • created_at — TIMESTAMP

Message (messages)

  • message_id — INT — Primary key
  • sender_id (user_id) — INT — Foreign key → User.user_id
  • receiver_id (user_id2) — INT — Foreign key → User.user_id
  • content — TEXT — NOT NULL
  • read_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

PaymentHistory (payment_histories)

  • payment_history_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • amount — INT — NOT NULL
  • status — ENUM('SUCCESS','FAIL','CANCELED','PENDING') — NOT NULL
  • method — ENUM('CARD','TOSS','KAKAO','NAVER') — NOT NULL
  • portone_payment_id — VARCHAR(255)
  • portone_order_id — VARCHAR(255)
  • error_code — VARCHAR(255)
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

Post

  • post_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • content — TEXT
  • like_count (Field) — INT
  • status — ENUM('VISIBLE','INVISIBLE','DELETED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • place (Field2) — VARCHAR(200)

PostBookmark (CopyOfCopyOfPost)

  • id (Key) — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → Post.post_id
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • created_at — TIMESTAMP

PostLike (CopyOfPost)

  • id (Key) — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → Post.post_id
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • created_at — TIMESTAMP

PrivacyAgreement

  • agreement_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • version — VARCHAR(20)
  • agreed_at — TIMESTAMP
  • expired_at — TIMESTAMP

Report

  • report_id — INT — Primary key
  • post_id (post_id2) — INT — Foreign key → Post.post_id
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • reason — TEXT
  • created_at — TIMESTAMP

SocialAccount (social_account)

  • social_account_id (id) — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • provider — ENUM('KAKAO','GOOGLE') — NOT NULL
  • provider_user_id — VARCHAR(64) — NOT NULL
  • connected_at — TIMESTAMP

SubscriptionHistory (subscription_histories)

  • subscription_history_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • payment_history_id — INT — Foreign key → PaymentHistory.payment_history_id
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — ENUM('ACTIVE','EXPIRED','CANCELED') — NOT NULL
  • reason — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

User

  • user_id — INT — Primary key
  • username — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • birthday (Field4) — DATE
  • email — VARCHAR(150)
  • phone — VARCHAR(20)
  • profile_image_url (Field2) — VARCHAR(500)
  • status — ENUM('ACTIVE','INACTIVE','BLOCKED','DELETED')
  • role (Field) — ENUM('USER', 'ADMIN')
  • login_type (Field3) — ENUM('LOCAL','SOCIAL')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP