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