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