DaesoGO
Tables (7)
board
- bo_id — VARCHAR(255) — Primary key — NOT NULL
- bo_content — VARCHAR(10000) — NOT NULL
- createAt — DATETIME — NOT NULL
- FK_exercise — VARCHAR(255) — Foreign key → exercise.ex_title
- FK_user — VARCHAR(50) — Foreign key → user.us_id
- INDEX — `FK_f6ecf520684b1177aaed8bea31b`
- INDEX — `FK_fb7256ed35a3cc7566d521928f0`
comment
- co_id — INT — Primary key — NOT NULL
- co_content — VARCHAR(255) — NOT NULL
- co_createAt — DATETIME — NOT NULL
- FK_board — VARCHAR(255) — Foreign key → board.bo_id
- FK_user — VARCHAR(50) — Foreign key → user.us_id
- INDEX — `FK_5271f908bbc0dd705104a9b6e79`
- INDEX — `FK_e8a822be0a406b68c88e57c6a4b`
diary
- di_id — INT — Primary key — NOT NULL
- di_content — VARCHAR(6000) — NOT NULL
- di_photo — VARCHAR(300) — NOT NULL
- di_createAt — DATETIME — NOT NULL
- FK_user — VARCHAR(50) — Foreign key → user.us_id — NOT NULL
- INDEX — `FK_280392ed7cf81eb84425f0dfab0`
exercise
- ex_title — VARCHAR(255) — Primary key — NOT NULL
- ex_muscle — VARCHAR(255) — NOT NULL
- ex_difficulty — INT — NOT NULL
- ex_explanation — VARCHAR(1024) — NOT NULL
- ex_precautions — VARCHAR(255) — NOT NULL
- ex_videoFile — VARCHAR(1024) — NOT NULL
fruit
- fr_id — INT — Primary key — NOT NULL
- fr_name — VARCHAR(255) — NOT NULL
- fr_content — VARCHAR(3000) — NOT NULL
- fr_img — VARCHAR(500) — NOT NULL
recommend
- re_id — INT — Primary key — NOT NULL
- re_hour — INT — NOT NULL
- re_exercisesName — VARCHAR(255)
- re_fruitsName — VARCHAR(255)
- FK_user — VARCHAR(50) — Foreign key → user.us_id
user
- us_id — VARCHAR(50) — Primary key — NOT NULL
- us_nickname — VARCHAR(50) — NOT NULL
- us_password — VARCHAR(200) — NOT NULL
- us_sex — VARCHAR(2) — NOT NULL
- us_age — VARCHAR(10) — NOT NULL
- us_interest — VARCHAR(200) — NOT NULL
- us_diary_pu_yn — TINYINT — NOT NULL