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 — 수정시간