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