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