af

Tables (6)

Category (Untitled5)

  • idx — number — Primary key — NOT NULL
  • name — string

Comment (Untitled3)

  • idx — number — Primary key — NOT NULL
  • userId — string — Foreign key → User.id — NOT NULL
  • postIdx — number — Foreign key → Post.idx — NOT NULL
  • idx (idx2) — number — Foreign key → Post.categoryIdx — NOT NULL
  • content — string
  • created_at (createdAt) — date

Post (Untitled2)

  • idx — number — Primary key — NOT NULL
  • id (userId) — string — Foreign key → User.id — NOT NULL
  • categoryIdx — number — Foreign key → Category.idx — NOT NULL
  • title — string
  • content — string
  • image — string

PostLIke (Untitled6)

    Report (Untitled4)

    • idx — number — Primary key — NOT NULL
    • postIdx — number — Foreign key → Post.idx — NOT NULL
    • userId — string — Foreign key → Post.id — NOT NULL
    • categoryIdx — number — Foreign key → Post.categoryIdx — NOT NULL

    User (Untitled)

    • id (userId) — string — Primary key — NOT NULL
    • pw — string
    • nickname (nickName) — string
    • local — string