pandamarket

Tables (6)

article_likes

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • article_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

articles

  • id — BIGSERIAL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — NOT NULL

comments

  • id — BIGSERIAL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT
  • article_id — BIGINT

product_likes

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

products

  • id — BIGSERIAL
  • name — TEXT — NOT NULL
  • description — TEXT — NOT NULL
  • price — INTEGER — NOT NULL
  • tags — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — NOT NULL

users

  • id — BIGSERIAL
  • email — TEXT — NOT NULL
  • nickname — TEXT — NOT NULL
  • image — TEXT
  • password — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL