gds
Tables (7)
account
- account_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- word — varchar(255)
tbl_category
- category_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- category_eng_description — varchar(255) — NOT NULL
- category_kor_description — varchar(255) — NOT NULL
- category_name — varchar(255) — NOT NULL
- org_category_id — bigint
tbl_contact
- contact_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- additional_info — varchar(255) — NOT NULL
- address — varchar(255) — NOT NULL
- contactor — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- phone_number — varchar(255) — NOT NULL
tbl_media
- media_id (Key) — bigint — Primary key — NOT NULL
- classification — varchar(255) — NOT NULL
- content_id — bigint
- local_upload_url — varchar(255) — NOT NULL
- media_name — varchar(255) — NOT NULL
- media_upload_url — varchar(255) — NOT NULL
- media_uuid_title — varchar(255) — NOT NULL
tbl_product
- product_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- file_eng_local_upload_url — varchar(255) — NOT NULL
- file_eng_name — varchar(255)
- file_eng_upload_url — varchar(255) — NOT NULL
- file_kor_local_upload_url — varchar(255) — NOT NULL
- file_kor_name — varchar(255)
- file_kor_upload_url — varchar(255) — NOT NULL
- local_product_img_url — varchar(255) — NOT NULL
- menu_expression — varchar(255)
- product_descript_eng — longtext — NOT NULL
- product_descript_kor — longtext — NOT NULL
- product_eng_name — varchar(255)
- product_img_url — varchar(255) — NOT NULL
- product_name — varchar(255) — NOT NULL
- product_spec_eng — longtext — NOT NULL
- product_spec_kor — longtext — NOT NULL
- category_id (Key2) — bigint — Foreign key → tbl_category.category_id — NOT NULL
tbl_project
- project_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- date — varchar(255) — NOT NULL
- description — longtext
- description_eng — longtext
- local_img_url — varchar(255)
- location_eng — varchar(255) — NOT NULL
- location_kor — varchar(255) — NOT NULL
- project_img — varchar(255)
- title_eng — varchar(255) — NOT NULL
- title_kor — varchar(255) — NOT NULL
token
- token_id (Key) — bigint — Primary key — NOT NULL
- token — varchar(255)