TRAVEL MAKER
Tables (4)
diary_reply (4)
- reply — 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)
- id — varchar(50) — Primary key — NOT NULL
- password — varchar(50)
- 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)
- imglocs — varchar(3000)
- 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)
- view_cnt — int