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