My homepage

Tables (5)

tb_contact

  • seq — int — Primary key — NOT NULL — sequnce of table
  • subject — varchar(512) — NOT NULL — subject
  • name — varchar(128) — NOT NULL — name
  • email — varchar(256) — NOT NULL — email
  • content — text — NOT NULL — content
  • reg_dt — datetime — NOT NULL — added on

tb_travel

  • idx — int — Primary key — NOT NULL — index
  • place — varchar(255) — NOT NULL — place of trip
  • begin_dt — varchar(10) — NOT NULL — begin of date of trip
  • end_dt — varchar(10) — NOT NULL — end of date of trip
  • pos_lat — decimal(3,12) — NOT NULL — latitude
  • pos_lon (po_lon) — decimal(3,12) — NOT NULL — longitude
  • describe — text — NOT NULL — describe of trip
  • icon_path — varchar(126) — NOT NULL — path of icon

tb_travel_file

  • file_seq — int — Primary key — NOT NULL — sequnce of file
  • idx — int — Foreign key → tb_travel.idx — NOT NULL — index
  • file_nm — varchar(128) — NOT NULL — file name
  • file_path — varchar(256) — NOT NULL — file path

tb_work_file

  • file_seq (fike_seq) — int — Primary key — NOT NULL — sequnce of file
  • idx — bigint(20) — Foreign key → tb_works.idx — NOT NULL
  • file_path — varchar(256) — NOT NULL — file path

tb_works

  • idx — bigint(20) — Primary key — NOT NULL — index of work
  • job_title — varchar(128) — NOT NULL — job title
  • project_nm — varchar(128) — NOT NULL — project name
  • client — varchar(128) — NOT NULL — client name
  • start_dt — varchar(10) — NOT NULL — start date
  • end_dt — varchar(10) — NOT NULL — end date