comon
Tables (12)
t_auth
- auth_idx — INT(11) — Primary key — NOT NULL
- auth_name — VARCHAR(50) — NOT NULL
t_category
- category_idx — INT(11) — Primary key — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
t_deny
- deny_idx — INT(11) — Primary key — NOT NULL
- deny_name — VARCHAR(50) — NOT NULL
t_image
- image_idx — INT(11) — Primary key — NOT NULL
- image_name — VARCHAR(50) — NOT NULL
- thumbnail_image — VARCHAR(500) — NOT NULL — 썸네일 이미지
- image_description — VARCHAR(500) — NOT NULL — 이미지 간단한 설명
- image_detail — VARCHAR(500) — 이미지 자세한 설명
- category_idx — INT(11) — Foreign key → t_category.category_idx
- icon_image — VARCHAR(500) — NOT NULL
- yaml_file — VARCHAR(500) — NOT NULL
- user_idx — INT(11) — Foreign key → t_user.user_idx
- status_idx — INT(11) — Foreign key → t_status.status_idx
- deny_idx — INT(11) — Foreign key → t_deny.deny_idx
- screenshot_image1 — VARCHAR(500)
- screenshot_image2 — VARCHAR(500)
- screenshot_image3 — VARCHAR(500)
- screenshot_image4 — VARCHAR(500)
- screenshot_image5 — VARCHAR(500)
- screenshot_image6 — VARCHAR(500)
- regist_dt — DATETIME
- delete_dt — DATETIME
- randon_num — MEDIUMINT
- download_count — INT(11)
- user_id (user_id2) — VARCHAR(20) — Foreign key → t_user.user_id — NOT NULL
t_image_review
- review_idx — INT(11) — Primary key — NOT NULL
- image_idx — INT(11) — Foreign key → t_image.image_idx
- review_title — VARCHAR(50) — NOT NULL
- review_content — VARCHAR(500) — NOT NULL
- regist_dt — DATETIME
- user_idx — INT(11) — Foreign key → t_user.user_idx
- score_count — INT(11)
- user_id (user_id2) — VARCHAR(20) — Foreign key → t_user.user_id — NOT NULL
t_image_user
- image_idx — INT(11) — Foreign key → t_image.image_idx
- user_idx — INT(11) — Foreign key → t_user.user_idx
- delete_yn — VARCHAR(1) — NOT NULL
- springboot_port — INT(11)
- react_port — INT(11)
- download_date — DATETIME
- user_id (user_id2) — VARCHAR(20) — Foreign key → t_user.user_id — NOT NULL
t_image_user_dev
- user_idx — INT(11) — Foreign key → t_user.user_idx
- image_idx — INT(11) — Foreign key → t_image.image_idx
- user_id (user_id2) — VARCHAR(20) — Foreign key → t_user.user_id — NOT NULL
t_notice
- notice_idx — INT(11) — Primary key — NOT NULL
- notice_title — VARCHAR(50) — NOT NULL
- notice_category_idx — INT(11) — Foreign key → t_notice_category.notice_category_idx
- notice_content — VARCHAR(500) — NOT NULL
- regist_dt — DATETIME
t_notice_category
- notice_category_idx — INT(11) — Primary key — NOT NULL
- notice_category_name — VARCHAR(50) — NOT NULL
t_port
- port_number — INT(11) — Primary key — NOT NULL
- usable_yn — VARCHAR(1) — NOT NULL
t_status
- status_idx — INT(11) — Primary key — NOT NULL
- status_name — VARCHAR(50) — NOT NULL
t_user
- user_idx — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(20) — Primary key — NOT NULL
- user_name — VARCHAR(10) — NOT NULL
- user_password — VARCHAR(200) — NOT NULL
- user_phone_number — VARCHAR(20) — NOT NULL
- user_email — VARCHAR(50) — NOT NULL
- auth_idx — INT(11) — Foreign key → t_auth.auth_idx
- sign_date — DATETIME