todayshouse_ERD

Tables (6)

Comment (Untitled3)

  • comment_id (Field) — INTEGER
  • post_id (Field2) — INTEGER
  • user_id (Field3) — INTEGER
  • content (Field4) — TEXT
  • created_at (Field5) — DATETIME

like (Untitled5)

  • like_id (Field) — INTEGER
  • user_id (Field2) — INTERGER
  • post_id (Field3) — INTEGER

order (Untitled4)

  • order_id (Field) — INTEGER
  • user_id (Field2) — INTEGER
  • total_price (Field3) — DECIMAL
  • status (Field4) — VARCHAR
  • ordered_at (Field5) — DATETIME

post (Untitled6)

  • post_id (Field) — INTEGER
  • user_id (Field2) — INTEGER
  • title (Field3) — VARCHAR
  • description (Field4) — TEXT

product (Untitled2)

  • product__id (Field) — INTEGER
  • name (Field2) — VARCHAR
  • description (Field3) — TEXT
  • price (Field4) — DECIMAL
  • image_url (Field5) — VARCHAR
  • category (Field6) — VARCHAR
  • stock_quantity (Field7) — INTEGER

user (Untitled)

  • user_id (Field) — INTERGER
  • username (Field2) — VARCHAR
  • email (Field3) — VARCHAR
  • password (Field4) — VARVHAR
  • profile_image (Field5) — VARCHAR
  • created_at (Field6) — DATETIME