panda_market
Tables (11)
article_comments
- id — SERIAL
- user_id — INT — NOT NULL
- article_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
article_images
- id — SERIAL
- article_id — INT — NOT NULL
- url — TEXT — NOT NULL
article_like
- user_id — INT
- article_id — INT
- created_at — TIMESTAMP
articles
- id — SERIAL
- user_id — INT
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
product_comments
- id — SERIAL
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
product_images
- id — SERIAL
- product_id — INT — NOT NULL
- url — TEXT — NOT NULL
product_like
- user_id — INT
- product_id — INT
- created_at — TIMESTAMP
product_tags
- tag_id — INT
- product_id — INT
products
- id — SERIAL
- user_id — INT — NOT NULL
- name — TEXT — NOT NULL
- description — TEXT — NOT NULL
- price — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
tags
- id — SERIAL
- name — TEXT — NOT NULL
users
- id — SERIAL — Primary key
- email — TEXT — NOT NULL
- nickname — TEXT — NOT NULL
- password — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP