HowTrip

Tables (6)

board

  • board_id — number — Primary key — NOT NULL
  • title — varchar2 — NOT NULL
  • board_content — varchar2 — NOT NULL
  • views — number
  • like_cnt — number
  • created_time — date — NOT NULL
  • update_time — date
  • user_id — varchar2 — NOT NULL

board_like

  • board_like_id — number — Primary key — NOT NULL
  • board_id — number — NOT NULL
  • user_id — varchar2 — NOT NULL

bookmark

  • bm_id — number — Primary key — NOT NULL
  • user_id — varchar2 — NOT NULL
  • content_id — number — NOT NULL
  • bm_title — varchar2 — NOT NULL
  • url_address — varchar2 — NOT NULL
  • img_address — varchar2 — NOT NULL

comment

  • comment_id — number — Primary key — NOT NULL
  • comment_content — varchar2 — NOT NULL
  • created_time — date — NOT NULL
  • update_time — date
  • user_id — varchar2 — NOT NULL
  • board_id — number — NOT NULL

comment_reply

  • reply_id — number — Primary key — NOT NULL
  • reply_content — varchar2 — NOT NULL
  • created_time — date — NOT NULL
  • update_time — date
  • user_id — varchar2 — NOT NULL
  • board_id — number — NOT NULL
  • comment_id — number — NOT NULL

member

  • user_id — varchar2 — Primary key — NOT NULL
  • Field (user_pwd) — varchar2 — NOT NULL
  • name — varchar2 — NOT NULL
  • birth — date — NOT NULL
  • gender — varchar2 — NOT NULL
  • email — varchar2 — NOT NULL
  • tel — number