IamTest
Tables (9)
Copy Of Copy Of Copy Of Untitled2 (REPLY)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (user_id) — BIGINT — Foreign key → Untitled2.Key — NOT NULL — FK
- Key (posting_file_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL — FK
- Field (contents) — VARCHAR(256) — NOT NULL — 댓글 내용
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
Copy Of Copy Of Copy Of Untitled22 (PRODUCT_FILE)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (product_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL — FK
- Field (file_path) — VARCHAR(512) — NOT NULL — 파일 저장된 경로
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
Copy Of Copy Of Copy Of Untitled23 (POSTING_PRODUCT_FILE_RELATION)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (product_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL — FK
- Key (posting_file_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL — FK
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
- Field (product_link_x) — DECIMAL() — 포스팅 파일에 매핑된 상품 이미지와 X 좌표값
- Field (product_link_y) — DECIMAL — 포스팅 파일에 매핑된 상품 이미지와 Y 좌표값
Copy Of Copy Of Copy Of Untitled232 (CATEGORY_CODE)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (parent_category_id) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Untitled232.Key — FK(부모 category_pk) Null인경우 ROOT 카테고리로 판단한다
- Field (name) — VARCHAR(128) — NOT NULL — 카테고리 키워드
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
Copy Of Copy Of Untitled2 (POSTING_FILE)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (user_id) — BIGINT — Foreign key → Untitled2.Key — NOT NULL — FK
- Key (style_code_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled23.Key — NOT NULL — FK
- Key (category_depth1_id) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Untitled232.Key — NOT NULL — FK(카테고리depth1)
- Key (category_depth2_id) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Untitled232.Key — FK(카테고리 depth2)
- Field (file_path) — VARCHAR(512) — NOT NULL — 파일 저장된 경로
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
- Field (like_cnt) — INTEGER — NOT NULL — 좋아요 CNT
Copy Of Copy Of Untitled22 (PRODUCT)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (user_id) — BIGINT — Foreign key → Untitled2.Key — NOT NULL — FK (사이트운영자)
- Key (category_depth1) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Untitled232.Key — NOT NULL — FK(카테고리depth2)
- Key (category_depth2) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Untitled232.Key — FK(카테고리depth2)
- Field (price) — int(11) unsigned — 가격
- Field (like_cnt) — INTEGER — NOT NULL — 좋아요 CNT
- Field (purchase_link) — VARCHAR(512) — 구매 가능한 URL
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
Copy Of Copy Of Untitled23 (STYLE_CODE)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Field (name) — VARCHAR(128) — NOT NULL — 스타일 키워드
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
Copy Of Untitled22 (USER_SOCIAL_AUTH)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Key (user_id) — BIGINT — Foreign key → Untitled2.Key — NOT NULL — FK
- Field (provider) — VARCHAR(256) — NOT NULL — ex: kakao, naver, facebook
- Field (extra_data) — JSON — NOT NULL — 외부인증서버에서가져온 기타 정보
- Field2 (uid) — VARCHAR(256) — NOT NULL — 식별정보
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간
Untitled2 (USER)
- Key (id) — BIGINT — Primary key — NOT NULL — 기본키
- Field (email) — VARCHAR(256) — NOT NULL — ..
- Field (password) — VARCHAR(128) — NOT NULL — ...
- Field2 (user_type) — ENUM('customer','vendor') — NOT NULL — ...
- Field (created_at) — DATETIME(8) — NOT NULL — 생성시간
- Field (modified_at) — DATETIME(8) — NOT NULL — 수정시간