Fruitte

Tables (8)

Untitled (User)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Field (name) — varchar(20) — NOT NULL — max_length=20, unique=True, null=False, blank=False
  • Field (password) — varchar(256) — NOT NULL — max_length=256, null=False, blank=False
  • Field2 (email) — varchar(100) — NOT NULL — max_length=100, unique=True
  • Field (join_date) — datetime — NOT NULL — auto_now_add=True
  • Field2 (profile_img) — image — blank=True
  • Field4 (is_active) — bool — NOT NULL — default=True
  • Field (is_admin) — bool — NOT NULL — default=False

Untitled (Review)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Key (author_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Key (product_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Field2 (review_content) — text — NOT NULL
  • Field (review_rating) — integer — NOT NULL
  • Field (created_at) — datetime — NOT NULL — auto_now_add=True

Untitled (PurchasedList)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Key (product_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Field (pay_method_id) — bigint — NOT NULL — on_delete=models.CASCADE
  • Field (purchased_at) — datetime — NOT NULL — auto_now_add=True
  • Field (delivery_status) — bigint — NOT NULL — on_delete=models.CASCADE
  • Field (is_present) — bool — NOT NULL — default=True

Untitled (PayMethod)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Key (pay_method) — varchar(10) — Foreign key → Untitled.Key — NOT NULL — max_length=10

Untitled (DeliveryStatus)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Key (delivery_status) — varchar(10) — Foreign key → Untitled.Key — NOT NULL — max_length=10

Untitled (Cart)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Key (product_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Field (is_present) — bool — NOT NULL — default=True

Untitled (Product)

  • Key (id) — integer — Primary key — NOT NULL — PK
  • Field (product_name) — varchar(100) — NOT NULL — max_length=100
  • Field (thumbnail) — image — blank=True
  • Field (detail_image) — image — blank=True
  • Field (product_description) — text
  • Field (register_date) — datetime — NOT NULL — auto_now_add=True
  • Field (is_public) — bool — NOT NULL — default=False

Untitled (ProductOption)

  • Key (product_id) — bigint — Foreign key → Untitled.Key — NOT NULL — on_delete=models.CASCADE
  • Field (product_option_detail) — varchar(50) — max_length=50
  • Field (product_price) — integer — NOT NULL
  • Field (product_amount) — integer — NOT NULL — blank=True