NOTEMPLE

Tables (11)

AssetLog(TimeStamped) (Untitled8)

  • assetlog_pk — PK, AI — Primary key — NOT NULL
  • user — FK
  • cash — NN

Cart (Untitled7)

  • cart_pk — PK, AI — Primary key — NOT NULL
  • user — OneToOne
  • products — ManyToMany

Category (Untitled4)

  • category_pk — PK, AI — Primary key — NOT NULL
  • product_pk — PK, AI — Foreign key → Product(TimeStamped).product_pk — NOT NULL
  • name — NN, unique
  • product — FK

CategoryType (Untitled6)

  • type_pk — PK, AI — Primary key — NOT NULL
  • category_pk — PK, AI — Foreign key → Category.category_pk — NOT NULL
  • product_pk — PK, AI — Foreign key → Category.product_pk — NOT NULL
  • name — NN, unique
  • category — FK

Follow !! (Untitled)

  • follow_pk — PK, AI — Primary key — NOT NULL
  • follower — FK
  • followee — FK

Like (Untitled10)

  • like_pk — PK, AI — Primary key
  • user — OneToOne
  • products — ManyToMany

Product(TimeStamped) (Untitled2)

  • product_pk — PK, AI — Primary key — NOT NULL
  • seller — FK
  • name — NN
  • price — PK, NN
  • description — NN
  • product_url — NN
  • cover — NN
  • is_publish — default=False
  • is_approved — default=False

Sell(TimeStamped) (Untitled5)

  • product_pk — PK, AI — Foreign key → Product(TimeStamped).product_pk — NOT NULL
  • sell_pk — PK, AI
  • product — FK
  • buyer — FK(user)

Seller (Untitled3)

  • seller_pk — PK, AI — Primary key — NOT NULL
  • user — OneToOne
  • address — NN
  • alert — default=False
  • business_type — NN
  • bio — null=True
  • 이외 필드 추가 예정 (Field)

TimeStamped (Untitled9)

  • pk — PK, AI — Primary key — NOT NULL
  • created_at — NN
  • updated_at — NN
  • deleted_at — null=True

User

  • user_pk — PK, AI — Primary key — NOT NULL
  • cart_pk — PK, AI — Foreign key → Cart.cart_pk — NOT NULL
  • name — NN
  • password — NN
  • email — NN, unique
  • nickname
  • phone_number — NN, unique
  • avatar
  • likes — OneToOne
  • cart — OneToOne
  • follow !! — OneToOne
  • asset — default=0