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