연습
테이블 (7)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (tag_post_map)
- Key (tag_post_map_id) — BIGINT — 기본 키 — NOT NULL
- Key (post_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Key (tag_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (tags)
- Key (tag_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR(20)
Copy Of Copy Of Copy Of Copy Of Untitled (posts)
- Key (post_id) — BIGINT — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (content) — VARCHAR(100)
Copy Of Copy Of Copy Of Untitled (comments)
- Key (comments_id) — BIGINT — 기본 키 — NOT NULL
- Key (post_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Field (content) — VARCHAR(100)
- Field2 (timestamp) — TIMESTAMP
Copy Of Copy Of Untitled (users)
- Key (user_id) — BIGINT — 기본 키 — NOT NULL
- Field (email) — VARCHAR(50)
- Field2 (password) — VARCHAR(50)
- Field (name) — VARCHAR(50)
Copy Of Untitled (likes)
- Key (likes_id) — BIGINT — 기본 키 — NOT NULL
- Key (comments_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Key (post_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Field (target_id) — BIGINT
- Field2 (timestamp) — TIMESTAMP
- Field (target_type) — INTEGER
Untitled (follower_map)
- Key (follower_id) — BIGINT — 기본 키 — NOT NULL
- Key (following_id) — BIGINT — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
- Field (target_id) — BIGINT