Aurora Database
Tables (15)
Comment (댓글)
- PK (comment_id) — bigint — Primary key
- FK (user_id) — bigint — Foreign key → User.PK
- FK (commentable_id) — bigint
- (commentable_type) — String
- (deleted_at) — datetime
Filter (필터)
- PK (filter_id) — bigint — Primary key
- FK (user_id) — bigint — Foreign key → User.PK
- (filter_data_path) — String
- (filter_name) — String
- (created_at) — datetime
- (updated_at) — datetime
Follow (팔로우)
- PK (follow_id) — bigint — Primary key
- FK (follower_id) — bigint — Primary key
- FK (followable_id) — bigint — Primary key
- (follower_type) — String
- (followable_type) — String
- (created_at) — datetime
History (판매내역)
- FK (Field) — bitint — Primary key
- PK (history_id) — datetime — Primary key
- FK (filter_id) — bigint — Foreign key → Filter.PK
- PK (user_id) — bigint — Foreign key → User.PK
- (amount) — datetime
- (state) — String
- (created_at) — datetime
- (updated_at) — datetime
- (exchanged_at) — datetime
Like (좋아요)
- PK (like_id) — bigint — Primary key
- FK (liker_id) — bigint
- FK (likeable_id) — bigint
- (liker_type) — String
- (likeable_type) — String
- (created_at) — datetime
LineFilter (주문에 담긴 필터)
- PK (line_filter_id) — bigint — Primary key
- FK (post_id) — bigint — Foreign key → Post.PK
- FK (filter_id) — bigint — Foreign key → Post.FK
- PK (order_id) — bigint — Foreign key → Order.PK
- (amount) — integer
- (check) — boolean
- (created_at) — datetime
- (updated_at) — datetime
Order (주문)
- PK (order_id) — bigint — Primary key
- FK (user_id) — bigint — Foreign key → User.PK
- (total) — integer
- - (state) — String
- (created_at) — datetime
- (updated_at) — datetime
- (purchased_at) — datetime
- (canceled_at) — datetime
Package (판매 상품)
- PK (package_id) — bigint — Primary key
- (title) — String
- (price) — integer
- (created_at) — datetime
- (updated_at) — datetime
Payment (결제내역)
- PK (payment_id) — bigint — Primary key
- FK (user_id) — bigint — Foreign key → User.PK
- FK (package_id) — bigint — Foreign key → Package.PK
- (state) — String
- (merchant_uid) — String
- (amount) — integer
- (created_at) — datetime
- (updated_at) — datetime
- (paid_at) — datetime
- (canceled_at) — datetime
Post (게시물)
- PK (post_id) — bigint — Primary key
- FK (user_id) — bigint — Foreign key → User.PK
- FK (filter_id) — bigint — Foreign key → Filter.PK
- (title) — String
- (description) — text
- (price) — integer
- (likers_count) — integer
- (created_at) — datetime
- (updated_at) — datetime
- (deleted_at) — datetime
Report (신고)
- PK (report_id) — bigint — Primary key
- FK (user_id) — bigint
- FK (reportable_id) — bigint
- (reportable_type) — String
- (category) — integer
- (state) — String
- (content) — text
- (created_at) — datetime
- (updated_at) — datetime
Tag (태그)
- PK (tag_id) — bigint — Primary key
- (name) — String
- (taggings_count) — integer
- (created_at) — datetime
- (updated_at) — datetime
Tagging (-)
- PK (tag_id) — bigint — Foreign key → Tag.PK
- FK (taggable_id) — bigint
- FK (tagger_id) — bigint
- (taggable_type) — String
- (tagger_type) — String
- (context) — string
- (created_at) — datetime
User (사용자)
- PK (user_id) — bigint — Primary key
- (username) — String
- (email) — String
- (password) — String
- (followers_count) — integer
- (followees_count) — integer
- (cash) — integer
- (image) — String
- (created_at) — datetime — NOT NULL
- (updated_at) — datetime
UserFilter (사용자 필터)
- PK (user_filter_id) — integer — Primary key
- FK (filter_id) — bigint — Foreign key → Filter.PK
- FK (user_id) — bigint — Foreign key → User.PK
- (created_at) — datetime
- (updated_at) — datetime