dd
Tables (3)
image
- img_id — bigint(20) — Primary key — NOT NULL
- img_name — varchar(255)
- img_url — varchar(255)
- ori_img_name — varchar(255)
member
- member_id — bigint(20) — Primary key — NOT NULL
- address — varchar(255)
- backend — varchar(255)
- comment — varchar(198)
- education — varchar(255)
- email — varchar(255)
- frontend — varchar(255)
- github — varchar(255)
- mobile — varchar(255)
- name — varchar(255)
- password — varchar(255)
- phone — varchar(255)
- role — enum('ADMIN','USER')
- tools — varchar(255)
- userid — varchar(255)
- image_img_id — bigint(20) — Foreign key → image.img_id
project
- project_id — bigint(20) — Primary key — NOT NULL
- end_date — varchar(255)
- introduction — varchar(516)
- link — varchar(50)
- path — varchar(255)
- skills — varchar(516)
- start_date — datetime(6)
- title — varchar(27)
- image_img_id — bigint(20)
- member_id — bigint(20) — Foreign key → member.member_id