Aivle - Team10

Tables (7)

accounts_profile

  • id — int — Primary key — NOT NULL
  • phone_number — char(20)
  • nickname — char(30)
  • email — email
  • id (user_id) — int — Foreign key → auth_user.id — NOT NULL

accounts_usersession

  • id — int — Primary key — NOT NULL
  • session_key — char(40)
  • created_at — datetime
  • id (user_id) — int — Foreign key → auth_user.id — NOT NULL

auth_user

  • id — int — Primary key — NOT NULL
  • password — char
  • last_login — datetime
  • is_superuser — int
  • username — char
  • last_name — char
  • email — email
  • is_staff — int
  • is_active — int
  • date_joined — datetime
  • first_name — char

brd_comment

  • id — int — Primary key — NOT NULL
  • created — date
  • updated — datetime
  • deleted — boolean
  • content — char(300)
  • id (post_id) — int — Foreign key → brd_post.id — NOT NULL
  • id (user_id) — int — Foreign key → auth_user.id — NOT NULL

brd_post

  • id — int — Primary key — NOT NULL
  • title — char(250)
  • content (body) — text
  • ip — int
  • photo — image
  • id (user_id) — int — Foreign key → auth_user.id — NOT NULL

service_CameraImage (service_cameraimage)

  • id — int — Primary key — NOT NULL
  • image — image
  • timestamp — datetime

service_posturedetection

  • 기본키 (id) — int — Primary key — NOT NULL
  • posturetype — int
  • timehms — char(8)
  • timeymd — char(10)
  • id (user_id) — int — Foreign key → auth_user.id — NOT NULL