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