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