SaveWallet

Tables (8)

amount_info (.-)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • userId — Not Null
  • goalCount — Not Null
  • remainingAmount — Not Null
  • createdAt — DEFAULT current_timestamp
  • id (primary key2) — auto_increment — Foreign key → user.id — NOT NULL

post (--)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • userId — Not Null
  • title — Not Null
  • subject — Not Null
  • createdAt — DEFAULT current_timestamp
  • updatedAt — DEFAULT current_timestamp
  • id (primary key2) — auto_increment — Foreign key → user.id — NOT NULL

post_comment (.,)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • postId — Not Null
  • userId — Not Null
  • content — Not Null
  • createdAt — DEFAULT current_timestamp
  • updatedAt — DEFAULT current_timestamp
  • id (primary key2) — auto_increment — Foreign key → user.id — NOT NULL
  • id (primary key3) — auto_increment — Foreign key → post.id — NOT NULL

post_image (,)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • postId — Not Null
  • userId — Not Null
  • postImgPath — Not Null
  • createdAt — DEFAULT current_timestamp
  • updatedAt — DEFAULT current_timestamp
  • id (primary key2) — auto_increment — Foreign key → user.id — NOT NULL
  • id (primary key3) — auto_increment — Foreign key → post.id — NOT NULL

product (-)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • userId — Not Null
  • type — Not Null
  • itemName — Not Null
  • category — Not Null
  • amount — Not Null
  • purchasedCategory — Not Null
  • purchased — Not Null
  • size — Null
  • color — Null
  • datePurchased — Null
  • returnableDeadline — Null
  • usedHope — Not Null
  • productImgPath — Not Null
  • createdAt — DEFAULT current_timestamp
  • updatedAt — DEFAULT current_timestamp
  • id (primary key2) — auto_increment — Foreign key → user.id — NOT NULL

save (')

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • postId — Not Null
  • userId — Not Null
  • createdAt — DEFAULT current_timestamp
  • id (primary key3) — auto_increment — Foreign key → post.id — NOT NULL
  • id (primary key2) — auto_increment — Foreign key → user.id — NOT NULL

shopping_comment (...)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • productId — Not Null
  • userId — Not Null
  • content — Not Null
  • createdAt — DEFAULT current_timestamp
  • updatedAt — DEFAULT current_timestamp
  • id (primary key2) — auto_increment — Foreign key → product.id — NOT NULL
  • id (primary key3) — auto_increment — Foreign key → user.id — NOT NULL

user (.)

  • id (primary key) — auto_increment — Primary key — NOT NULL
  • loginId — Not Null
  • nickName — Not Null
  • password — Not Null
  • email — Not Null
  • age — Not Null
  • gender — Not Null
  • statusMessage — Null
  • profileImgPath — Null
  • createdAt — DEFAULT current_timestamp
  • updatedAt — DEFAULT current_timestamp