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