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