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