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