SecondHandMall

Tables (3)

Product (products)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • name (상품이름) — VARCAHR(20) — NOT NULL
  • content (상품내용) — VARCHAR(100) — NOT NULL
  • price (상품가격) — BIGINT — NOT NULL
  • seller_id (PK2) — VARCHAR — Foreign key → User.id — NOT NULL

Untitled

    User (users)

    • id (PK) — VARCHAR(20) — Primary key — NOT NULL
    • name (이름) — VARCHAR(20) — Primary key — NOT NULL
    • password (비밀번호) — VARCHAR(20) — NOT NULL