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