HISTORY TIMELINE

Tables (5)

article

  • id — INT — Primary key
  • regDate — DATETIME
  • updateDate — DATETIME
  • title — CHAR(100)
  • body — TEXT
  • memberId — INT — Foreign key → member.id — NOT NULL

csv1

  • id — INT — Primary key — NOT NULL
  • ruinsName — CHAR(100)
  • latitude — CHAR(100)
  • longitude — CHAR(100)
  • imageLink — TEXT
  • description — CHAR(200)

member

  • id — INT — Primary key — NOT NULL
  • regDate — DATETIME
  • updateDate — DATETIME
  • loginId — CHAR(100)
  • loginPw — CHAR(100)
  • name — CHAR(100)
  • nickname — CHAR(100)
  • score — INT
  • grade — ENUM
  • delStatus — TINYINT
  • delDate — DATETIME

question

  • id — INT — Primary key — NOT NULL
  • content — VACHAR(200)
  • answer — CHAR(200)

reply

  • id — INT — Primary key — NOT NULL
  • regDate — DATETIME
  • updateDate — DATETIME
  • body — TEXT
  • memberId — INT — Foreign key → member.id — NOT NULL
  • relId — INT — Foreign key → article.id