Literature
Tables (6)
Follow (회원 구독)
- id (Key) — bigint — Primary key — NOT NULL
- follower (Key2) — bigint — Foreign key → User.id — NOT NULL
- following (Key3) — bigint — Foreign key → User.id — NOT NULL
- created_at (Field) — datetime
Like (게시글 추천)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- post_id (Key3) — bigint — Foreign key → Post.id — NOT NULL
- created_at (Field3) — datetime
Post (게시글)
- id (Key) — bigint — Primary key — NOT NULL
- author (Key2) — bigint — Foreign key → User.id — NOT NULL
- tags (Key4) — bigint — Foreign key → Tag.id — NOT NULL
- title (Field) — varchar(20)
- type (Field2) — bigint
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
- content (Field3) — text
Profile (회원 프로필)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- nickname (Field2) — varchar(20)
- birth (Field3) — date
- bio (Field4) — text
Tag (게시글 태그)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
User (회원 아이디)
- id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar(255)
- password (Field2) — varchar(128)
- date_joined (Field3) — timestamp
- last_login (Field4) — timestamp
- is_active (Field5) — boolean
- is_superuser (Field6) — boolean
- is_staff (Field7) — boolean