shop

Tables (3)

article

  • articleId (Key1) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → user.userId — NOT NULL
  • nickname (Field1) — string
  • title (Field2) — string
  • content (Field3) — string
  • price (Field4) — number
  • category (Field5) — string
  • imageUrl (Field6) — string
  • shopUrl (Field7) — string
  • createdAt (Field8) — date

comment

  • commentId (Key) — Primary key — NOT NULL
  • articleId (Key1) — Foreign key → article.articleId — NOT NULL
  • userId (Key2) — Foreign key → article.userId — NOT NULL
  • nickname (Field) — string
  • comment (Field2) — string
  • createdAt (Field3) — date

user

  • userId (Key) — Primary key — NOT NULL
  • nickname (Field) — string
  • password (Field2) — string