CampusFind

Tables (5)

categories

  • id — BIGSERIAL
  • name — VARCHAR(50)

item_images

  • id — BIGSERIAL
  • item_id — BIGINT — Foreign key → items.id
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP

items

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id
  • category_id — BIGINT — Foreign key → categories.id
  • type — VARCHAR(20)
  • title — VARCHAR(100)
  • description — TEXT
  • reward_amount — INTEGER
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • location_text — VARCHAR(255)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

messages

  • id — BIGSERIAL
  • item_id — BIGINT — Foreign key → items.id
  • sender_id — BIGINT — Foreign key → users.id
  • receiver_id — BIGINT — Foreign key → users.id
  • content — TEXT
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

users

  • id — BIGSERIAL
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • nickname — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP