tetsErd

Tables (14)

answer

  • deleted — boolean — NOT NULL
  • answer_id — bigint
  • created_at — timestamp(6)
  • question_id — bigint
  • updated_at — timestamp(6)
  • content — varchar(255)
  • title — varchar(255)

auction

  • auction_id — bigint
  • bid_count — bigint
  • bid_unit — bigint
  • created_at — timestamp(6)
  • end_date — timestamp(6)
  • instant_buy_price — bigint
  • like_count — bigint — NOT NULL
  • member_id — bigint
  • now_price — bigint
  • start_date — timestamp(6)
  • start_price — bigint
  • updated_at — timestamp(6)
  • auction_status — varchar(255)
  • BIDDING::character — varying
  • NO_BIDS::character — varying
  • CONCLUDED::character — varying
  • COMPLETED::character — varying)::text))
  • content — text
  • thumbnail_path — varchar(255)
  • title — varchar(255)
  • category_id — bigint — NOT NULL

bid

  • auction_id — bigint
  • bid_id — bigint
  • bid_price — bigint
  • buyer_member_id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)

category

  • category_id — bigint
  • parent_id — bigint
  • name — varchar(255)
  • order_index — integer

chat

  • chat_id — bigint
  • created_at — timestamp(6)
  • room_id — bigint
  • sender_member_id — bigint
  • updated_at — timestamp(6)
  • message — varchar(255)
  • message_type — varchar(255)
  • CHAT::character — varying
  • LEAVE::character — varying)::text))

chatroom

  • auction_id — bigint
  • buyer_member_id — bigint
  • created_at — timestamp(6)
  • room_id — bigint
  • seller_member_id — bigint
  • updated_at — timestamp(6)
  • room_name — varchar(255)

conclude

  • auction_id — bigint
  • buyer_member_id — bigint
  • conclude_id — bigint
  • conclude_price — bigint
  • concluded_at — timestamp(6)

flyway_schema_history

  • installed_rank — integer — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — integer
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — integer — NOT NULL
  • success — boolean — NOT NULL

image

  • auction_id — bigint
  • image_id — bigint
  • file_name — varchar(255)
  • image_path — varchar(255)

likes

  • auction_id — bigint
  • created_at — timestamp(6)
  • likes_id — bigint
  • member_id — bigint

member

  • average_rating — double
  • created_at — timestamp(6)
  • member_id — bigint
  • updated_at — timestamp(6)
  • birth — date
  • email — varchar(255)
  • member_status — varchar(255)
  • DEACTIVATE::character — varying)::text))
  • nickname — varchar(255)
  • password — varchar(255)
  • phone_number — varchar(255)
  • profile_image_url — varchar(255)
  • provider — varchar(255)
  • provider_id — varchar(255)
  • role — varchar(255)
  • ROLE_USER::character — varying)::text))
  • username — varchar(255)
  • email_verified — boolean

notification

  • notification_id — bigserial
  • member_id — bigint
  • event_name — varchar(255) — NOT NULL
  • notification_code — varchar(255) — NOT NULL
  • data — text — NOT NULL
  • read — boolean — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

question

  • deleted — boolean — NOT NULL
  • auction_id — bigint — NOT NULL
  • created_at — timestamp(6)
  • member_id — bigint — NOT NULL
  • question_id — bigint
  • updated_at — timestamp(6)
  • content — varchar(255)
  • title — varchar(255)

review

  • rating — double
  • auction_id — bigint
  • created_at — timestamp(6)
  • recipient_member_id — bigint
  • review_id — bigint
  • reviewer_member_id — bigint
  • updated_at — timestamp(6)
  • content — varchar(255)
  • review_type — varchar(255)
  • BUY_REVIEW::character — varying)::text))