LINKPLUS

Tables (11)

FTPTB

  • FILE_ID — VARCHAR(20) — Primary key — NOT NULL
  • FILE_NM — VARCHAR(100)
  • FILE_PATH — VARCHAR(100)
  • FILE_EXTENSION — VARCHAR(5)
  • FILE_DIV — VARCHAR(5)
  • FILE_BLOB — BLOB
  • FILE_SEQ — NUMBER
  • FILE_SAVE — VARCHAR(100)

comment_log

  • date_edit — date — NOT NULL
  • comment_log — long — NOT NULL

commenttb

  • comment_number — number(20) — Primary key — NOT NULL
  • id_number(댓글작성자) (id_number) — number(20) — NOT NULL
  • comment_text — long
  • date_create — date — NOT NULL
  • date_edit — date
  • content_id — number(20) — Foreign key → contenttb.content_id — NOT NULL

content_file

  • file_id — number(20) — Foreign key → filetb.file_id — NOT NULL
  • content_id — number(20) — Foreign key → contenttb.content_id — NOT NULL
  • id_number — number(20) — Foreign key → contenttb.id_number — NOT NULL

contenttb

  • content_id — number(20) — Primary key — NOT NULL
  • id_number — number(20) — Foreign key → usertb.id_number — NOT NULL
  • category — varchar(20) — NOT NULL
  • content_title — varchar(40) — NOT NULL
  • content_text — long
  • view_count — number(20) — NOT NULL
  • vote_count — number(20) — NOT NULL
  • date_create — date — NOT NULL
  • date_edit (date_edite) — date
  • destination_id — number(20) — Foreign key → destination.destination_id

contenttb_log

  • content_id — number(20) — Foreign key → contenttb.content_id — NOT NULL
  • id_number — number(20) — Foreign key → contenttb.id_number — NOT NULL
  • date_edit — date — NOT NULL
  • content_log — long — NOT NULL

desti_file

  • destination_id — number(20) — Foreign key → destination.destination_id — NOT NULL
  • file_id — number(20) — Foreign key → filetb.file_id — NOT NULL

destination

  • destination_id — number(20) — Primary key — NOT NULL
  • destination_name — varchar(20) — NOT NULL
  • destination_short — varchar(255) — NOT NULL
  • destination_text — long
  • destination_vote — number(20) — NOT NULL
  • destination_location — varchar(30)
  • destination_GPS — varchar(20)

filetb

  • file_id — number(20) — Primary key — NOT NULL
  • size_file — number(20)
  • title — varchar(20) — NOT NULL
  • height_file — number(20)
  • width_file — number(20)
  • type_file — varchar(5) — NOT NULL
  • link — long
  • file_blob — blob

plannertb

  • id_number — number(20) — Foreign key → usertb.id_number — NOT NULL
  • destination_id — number(20) — Foreign key → destination.destination_id — NOT NULL
  • date_start — varchar
  • date_end — varchar
  • transport — varchar
  • destination_GPS — int

usertb

  • id_number — number(20) — Primary key — NOT NULL
  • ID (id_id) — varchar(20) — NOT NULL
  • Password (password_id) — varchar(20) — NOT NULL
  • email (email_id) — varchar(20) — NOT NULL
  • date_create — date — NOT NULL
  • del_id — int
  • user_name — varchar(10) — NOT NULL
  • nick_name — varchar(20) — NOT NULL
  • phone_number (tel_id) — varchar(20) — NOT NULL
  • admin_id (adimin_id) — int — NOT NULL