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