study
Tables (3)
Comment (Untitled)
- comment_id (Key) — BIGINT — Primary key — NOT NULL
- content_id — BIGINT — Foreign key → Content.content_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- created_date (Field) — DATETIME — NOT NULL
- last_modified_date (Field2) — DATETIME — NOT NULL
Content
- content_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- titile (Field) — VARCHAR — NOT NULL
- main_text (Field2) — TEXT
- dtype (Field3) — CHAR — NOT NULL
- completed (Field4) — TINYINT(1) — NOT NULL
- category (Field5) — VARCHAR — NOT NULL
- region (Field6) — VARCHAR — NOT NULL
- member_count (Field7) — INT
- created_date (Field8) — DATETIME — NOT NULL
- last_modified_date (Field9) — DATETIME — NOT NULL
Member
- member_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR
- access_token — VARCHAR — NOT NULL
- created_date (createdDate) — DATETIME — NOT NULL