FRIP X GH ERD 1123_use
Tables (7)
categoryLabel
- id — INT — Primary key — NOT NULL
- code — VARCHAR
- name — VARCHAR
click
- insert_id — VARCHAR — Primary key — NOT NULL
- prodcutId (productId) — INT
- userId — INT
- ts — TIMESTAMP
displayCategory
- id — INT — Primary key — NOT NULL
- categoryLabelId — INT
- categoryLabelCode — VARCHAR
product
- productId — INT — Primary key — NOT NULL
- overseasFlags — BOOLEAN
- title — VARCHAR
- kind — VARCHAR
- fripKinds — VARCHAR
- content — VARCHAR
- productStatus — VARCHAR
- standardCategoryIds — INT
- attributeIds — VARCHAR
- region — VARCHAR
- content_txt (content_text) — VARCHAR
- category_kr — LIST/VARCHAR
- loveClassify — INT
standardCategory
- id — INT — Primary key — NOT NULL
- idPath — VARCHAR
- codePath — VARCHAR
- categoryLabelId — INT
- categoryLabelCode — VARCHAR
- depth — INT
tagTemplate
- id — INT — Primary key — NOT NULL
- name — VARCHAR
- displayCategoryId — INT
- parentId — INT
userTag
- id — INT — Primary key — NOT NULL
- userId — INT
- tagTemplateId — INT