Project MLB
Tables (12)
Category
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
Comment
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Like
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT
- comment_id — BIGINT
- created_at — TIMESTAMP
Matching
- id — BIGINT
- user_id — BIGINT — NOT NULL
- match_type — VARCHAR(50)
- match_date — TIMESTAMP
- status — VARCHAR(50)
- created_at — TIMESTAMP
NewsSummary
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- summary — TEXT — NOT NULL
- created_at — TIMESTAMP
Post
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
PriceRecommendation
- id — BIGINT
- product_id — BIGINT — NOT NULL
- recommended_price — DECIMAL(10,2) — NOT NULL
- created_at — TIMESTAMP
Product
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- condition — VARCHAR(50)
- location — VARCHAR(255)
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Review
- id — BIGINT
- transaction_id — BIGINT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Ticket
- id — BIGINT
- event_name — VARCHAR(255) — NOT NULL
- event_date — DATE — NOT NULL
- seat — VARCHAR(50)
- price — DECIMAL(10,2) — NOT NULL
- user_id — BIGINT — NOT NULL
- transfer_status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Transaction
- id — BIGINT
- product_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- transaction_date — TIMESTAMP
- status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
User
- id — BIGINT
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP