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