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