NewBee

Tables (5)

Article (게시글)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • title (Field) — CharField(20)
  • content (Field2) — TextField
  • created_at (Field3) — DateTimeField
  • updated_at (Field4) — DateTimeField
  • id (Key2) — IntegerField — Foreign key → User.id — NOT NULL

Article_like_user (게시글 좋아요)

  • like_id (Key1) — IntegerField — Primary key — NOT NULL
  • id (Key2) — IntegerField — Foreign key → Article.id — NOT NULL
  • id (Key3) — IntegerField — Foreign key → User.id — NOT NULL

Deposit (정기예금)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • dcls_month (Field) — CharField(6)
  • fin_co_no (Field2) — CharField(10)
  • kor_co_nm (Field3) — CharField(100)
  • fin_prdt_cd (Field4) — CharField(10)
  • fin_prdt_nm (Field5) — CharField(100)
  • join_way (Field6) — CharField(50)
  • mtrt_int (Field7) — FloatField
  • spcl_cnd (Field8) — CharField(100)
  • join_deny (Field9) — TextField
  • join_member (Field10) — IntegerField
  • etc_note (Field11) — TextField
  • max_limit (Field12) — IntegerField
  • dcls_strt_day (Field13) — DateField
  • dcls_end_day (Field14) — DateField
  • fin_co_subm_day (Field15) — DateTimeField

User (유저)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • username (Field) — CharField(20)
  • realname (Field2) — CharField(20)
  • email (Field3) — EmailField(50)
  • birth (Field4) — DateField
  • age (Field5) — IntegerField
  • salary (Field9) — IntegerField
  • wealth (Field10) — IntegerField
  • is_staff (Field7) — BooleanField
  • date_joined (Field6) — DateTimeField
  • my_product (Field8) — JSONField

reply (댓글)

  • id (Key) — integer — Primary key — NOT NULL
  • content (Field) — text
  • id (Key2) — IntegerField — Foreign key → Article.id — NOT NULL
  • id (Key3) — IntegerField — Foreign key → User.id — NOT NULL