nanuri

Tables (7)

Category (categories)

  • id — BigAutoField — Primary key — NOT NULL
  • name — CharField
  • parent (category_id) — ForeignKey (Category.id) — Foreign key → Category.id — NOT NULL

Favorite Post (favorite_posts)

  • user (user_id) — BigAutoField — Foreign key → User.id — NOT NULL — Auto Increment
  • post (post_id) — BigAutoField — Foreign key → Post.id — NOT NULL

Kakao Account (kakao_accounts)

  • id — BigAutoField — Primary key — NOT NULL
  • user — OneToOneField (User.id) — Foreign key → User.id — NOT NULL — Auto Increment
  • kakao_id — PositiveBigIntegerField
  • created_at — DateTimeField
  • updated_at — DateTimeField

Participant (participants)

  • id — BigAutoField — Primary key — NOT NULL
  • user (user_id) — ForeignKey (User.id) — Foreign key → User.id — NOT NULL — Auto Increment
  • post (post_id) — ForeignKey (Post.id) — Foreign key → Post.id — NOT NULL

Post (posts)

  • id — BigAutoField — Primary key — NOT NULL
  • uuid — UUIDField
  • title — CharField
  • image — ImageField
  • unit_price — PositiveIntegerField
  • quantity — PositiveIntegerField
  • description — TextField
  • min_participants — PositiveIntegerField
  • max_participants — PositiveIntegerField
  • num_participants — PositiveIntegerField
  • product_url — URLField
  • trade_type — CharField
  • order_status — CharField
  • is_published — BooleanField
  • published_at — DateTimeField
  • view_count — PositiveBigIntegerField
  • waited_from — DateField
  • waited_until — DateField
  • created_at — DateTimeField
  • updated_at — DateTimeField
  • writer (user_id) — ForeignKey (User.id) — Foreign key → User.id — NOT NULL — Auto Increment
  • category (category_id) — ForeignKey (Category.id) — Foreign key → Category.id — NOT NULL

PostImage (post_images)

  • id — BigAutoField — Primary key — NOT NULL
  • post — ForeignKey (Post.id) — Foreign key → Post.id — NOT NULL
  • image — ImageField

User (users)

  • id — BigAutoField — Primary key — NOT NULL — Auto Increment
  • uuid — UUIDField
  • email — EmailField
  • password — CharField
  • nickname — CharField — NOT NULL
  • is_active — BooleanField
  • is_admin — BooleanField
  • latitude — FloatField
  • longitude — FloatField
  • address — CharField
  • profile (image) — ImageField
  • auth_provider — CharField
  • created_at — DateTimeField
  • updated_at — DateTimeField