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