DnD v2
Tables (7)
Category
- id — INT
- topic_id — INT — NOT NULL
- posts_id — INT — NOT NULL
Likes
- id — INT
- member_id — INT — NOT NULL
- posts_id — INT — NOT NULL
Member
- Field
- id — INT
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profileUrl — VARCHAR(255) — NOT NULL
Posts
- id — INT
- member_id — INT — NOT NULL
- content — TEXT — NOT NULL
- ref — TEXT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME
Relation
- id — INT
- followed_id — INT — NOT NULL
- follower_id — INT — NOT NULL
Reply
- id — INT
- posts_id — INT — NOT NULL
- member_id — INT — NOT NULL
- text — TEXT — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME
Topic
- id — INT
- name — VARCHAR(255) — NOT NULL