test

Tables (12)

auction_images

  • auction_id — BIGINT — Primary key — NOT NULL
  • image_id — BIGINT — Primary key — NOT NULL

auctions

  • id — BIGINT
  • seller_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • start_price — INT — NOT NULL
  • buy_now_price — INT — NOT NULL
  • upper_limit_price — INT — NOT NULL
  • lower_limit_price — INT
  • current_highest_bid — INT
  • bid_count — INT — NOT NULL
  • is_bid_public — SMALLINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • completed — SMALLINT — NOT NULL
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

bids

  • id — BIGINT
  • auction_id — BIGINT — NOT NULL
  • bidder_id — BIGINT — NOT NULL
  • price — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

categories

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • parent_id — BIGINT

chat_messages

  • id — BIGINT
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

chat_rooms

  • id — BIGINT
  • room_uuid — CHAR(36) — NOT NULL
  • product_type — VARCHAR(20) — NOT NULL
  • product_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

images

  • id — BIGINT
  • url — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_images

  • post_id — BIGINT — Primary key — NOT NULL
  • image_id — BIGINT — Primary key — NOT NULL

posts

  • id — BIGINT — Primary key
  • seller_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • price — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • deleted — SMALLINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

reputation_events

  • id — BIGINT
  • target_user_id — BIGINT — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL
  • ref_type — VARCHAR(20) — NOT NULL
  • ref_id — BIGINT — NOT NULL
  • delta — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

reputations

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • score — DECIMAL(4,2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • is_active — SMALLINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL