project
Tables (11)
Address
- addressId — long — Foreign key → User.userId
- addressName — varchar(255)
- addressUserName — varchar(255)
- phoneNumber — varchar(255)
- detailAdress — varchar(255)
- userId — long
Category
- categoryId — long — Foreign key → ItemCategory.ItemCategoryId
- categoryName — varchar(255)
- createdAt — localDateTime
- lastModifiedAt — localDateTime
Chat
- chatId — long
- createdAt — localDateTime
- lastModifiedAt — localDateTime
ChatRoom
- chatRoomId — long — Foreign key → Item.itemId
- chatRoomName — varchar(255)
- createdAt — localDateTime
- lastModifiedAt — localDateTime
Item
- itemId — long — Foreign key → OrderItem.orderItemId
- itemName — varchar(255)
- itemPicture — varchar(255)
- itemDelivery — varchar(255)
- itemPrice — long
- itemBody — varchar(255)
- itemPeopleNum — long
- itemDate — varchar(255)
- itemTag — varchar(255)
- itemStatus — varchar(255)
- itemPlace_X — double
- itemPlace_Y — double
- userId — long
- createdAt — localDateTime
- lastModifiedAt — localDateTime
ItemCategory
- ItemCategoryId — long — Foreign key → Item.itemId
- itemId — long
- categoryId — long
- createdAt — localDateTime
- lastModifiedAt — localDateTime
Order
- orderId — long — Foreign key → OrderItem.orderItemId
- userId — long
- orderPrice — long
- orderStatus — varchar(255)
- addressId — long
- createdAt — localDateTime
- lastModifiedAt — localDateTime
OrderItem
- orderItemId — long
- orderId — long
- ItemId — long
- waybillNumber — long
ShoppingCart
- shoppingCartId — long — Foreign key → Item.itemId
- shoppingCartSelected — boolean
- userId — long
- createdAt — localDateTime
- lastModifiedAt — localDateTime
User
- userId — long
- userName — varchar(255)
- nickName — varchar(255)
- email — varchar(255)
- password — varchar(255)
- userPicture — varchar(255)
- userStatus — varchar(enum)
- PRIVIDER_TYPE — varchar(enum)
- createdAt — localDateTime
- lastModifiedAt — localDateTime
Wish
- wishId — long — Foreign key → Item.itemId
- wishSelected — boolean
- userId — long
- createdAt — localDateTime
- lastModifiedAt — localDateTime