jdc

Tables (4)

auction_result

  • bid_id (Key3) — BIGSERIAL — Primary key — NOT NULL
  • post_id (Key) — BIGSERIAL — Foreign key → post.post_id — NOT NULL
  • user_id (Key2) — BIGSERIAL — Foreign key → user.user_id — NOT NULL
  • winning_price — BIGINT — NOT NULL
  • decided_at — TIMESTAMP — NOT NULL

bid (Untitled3)

  • bid_id (Key) — BIGSERIAL — Primary key — NOT NULL
  • price (Field) — BIGINT
  • post_id (Key2) — BIGSERIAL — Foreign key → post.post_id — NOT NULL
  • user_id (Key3) — BIGSERIAL — Foreign key → user.user_id — NOT NULL

post (Untitled2)

  • post_id (Key) — BIGSERIAL — Primary key — NOT NULL
  • seller_id (Key2) — BIGSERIAL — Foreign key → user.user_id — NOT NULL
  • title (Field) — varchar(30)
  • content (Field2) — text
  • image_url (Field3) — varchar(255)
  • gps_data (Field10) — varchar(255)
  • due_time (Field4) — TIMESTAMP
  • base_price (Field9) — BIGINT
  • top_price (Field8) — BIGINT
  • created_at (Field5) — TIMESTAMP
  • updated_at (Field6) — TIMESTAMP
  • deleted_at (Field7) — TIMESTAMP

user (Untitled)

  • user_id (Key) — BIGSERIAL — Primary key — NOT NULL
  • password (Field) — varchar(30)
  • email (Field2) — varchar(30)
  • token (Field3) — BIGINT
  • created_at (Field4) — TIMESTAMP
  • updated_at (Field5) — TIMESTAMP
  • deleted_at (Field6) — TIMESTAMP