tarvelmaker
Tables (4)
diary_reply (4)
- reply (reply2) — INT — Primary key — NOT NULL
- content — varchar(1000)
- writer — varchar(50)
- regdate — date
- diary_no — INT — Foreign key → traveler_diary.diary_no — NOT NULL
tbl_member (3)
- idi (id) — varchar(50) — Primary key
- password — varchar(100)
- name — varchar(100)
- email — varchar(100)
traveler_diary (2)
- diary_no — INT — Primary key — NOT NULL
- title — varchar(100)
- diary — varchar(3000)
- writer — varchar(20)
- regdate — date
- marker — varchar(3000)
- Field
- journal_no — INT — Foreign key → traveler_journal.journal_no — NOT NULL
traveler_journal (1)
- journal_no — INT — Primary key — NOT NULL
- title — varchar(100)
- start_dt — date
- end_dt — date
- marker — varchar(100)
- author — varchar(20)
- thumbs — INT
- view_cnt — INT