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