lv4

Tables (4)

cmts (댓글)

  • Key — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.userId — NOT NULL
  • postId — int — Foreign key → posts.postId — NOT NULL
  • content — str

posts (게시글)

  • postId — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.userId — NOT NULL
  • title — str
  • content — str
  • like — int

user (유저)

  • userId — Primary key — NOT NULL
  • email — str
  • password — int

userInfo (유저 정보)

  • userInfoId — Primary key — NOT NULL
  • userId — Foreign key → user.userId — NOT NULL
  • userDesc — str
  • createdAt — date
  • updatedAt — date