ziozio

테이블 (19)

Untitled (verification)

  • Key (verification_type) — CHAR(1) — 기본 키 — NOT NULL
  • userno (account_no) — NUMBER — 외래 키 → 계정필수정보.userno — NOT NULL
  • Field (verification_code) — CHAR(64)
  • Field (verification_date) — DATE

Untitled (color)

  • Key (color_code) — NUMBER — 기본 키 — NOT NULL
  • Field (color_name) — VARCHAR2(16)
  • Field (color_hue_rotate) — NUMBER
  • Field2 (color_saturate) — NUMBER
  • Field3 (color_brightness) — NUMBER

Untitled (cloth_temperature_grade)

  • Key (cloth_code) — NUMBER — 외래 키 → 의상정보.Key — NOT NULL
  • Key (temperature_grade_code) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

Untitled (temperature_grade)

  • Key (temperature_grade_code) — NUMBER — 기본 키 — NOT NULL
  • Field (temperature_grade_from) — NUMBER
  • Field (temperature_grade_to) — NUMBER

Untitled (account_like)

  • userno (account_no) — NUMBER — 외래 키 → 계정필수정보.userno — NOT NULL
  • Key (cloth_set_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

Untitled (cloth_set)

  • Key (cloth_set_no) — NUMBER — 기본 키 — NOT NULL
  • Key (cloth_code) — NUMBER — 외래 키 → 의상정보.Key — NOT NULL
  • Key (color_code) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

계정필수정보 (account)

  • userno (account_no) — NUMBER — 기본 키 — NOT NULL
  • Field (account_email) — VARCHAR2(100)
  • Field (account_pw) — CHAR(64)
  • Field (account_nick) — VARCHAR2(30)
  • Field (account_gender) — CHAR(1)
  • Field (account_signed_date) — DATE
  • Field (account_verified) — CHAR(1)
  • Key (account_grade_code) — NUMBER — 외래 키 → 유저등급.Key — NOT NULL

날씨데이터 (weather_info)

  • Key2 (weather_info_date) — DATE — 기본 키 — NOT NULL
  • Key (location_code) — NUMBER — 외래 키 → 지역.Key — NOT NULL
  • Key (weather_code) — NUMBER — 외래 키 → 날씨분류.Key — NOT NULL
  • Key (temperature_grade_code) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (weather_info_temperature) — NUMBER
  • Field (weather_info_finedust) — NUMBER

날씨별의상 (cloth_weather)

  • Key (cloth_code) — NUMBER — 외래 키 → 의상정보.Key — NOT NULL
  • Key (weather_code) — NUMBER — 외래 키 → 날씨분류.Key — NOT NULL

날씨분류 (weather)

  • Key (weather_code) — NUMBER — 기본 키 — NOT NULL
  • Field (weather_name) — VARCHAR2(30)

내옷장 (account_library)

  • userno (account_no) — NUMBER — 외래 키 → 계정필수정보.userno — NOT NULL
  • Key (cloth_code) — NUMBER — 외래 키 → 의상정보.Key — NOT NULL
  • Key (color_code) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

스타일별의상 (cloth_style)

  • Key (cloth_code) — NUMBER — 외래 키 → 의상정보.Key — NOT NULL
  • Key (style_code) — NUMBER — 외래 키 → 스타일코드.Key — NOT NULL

스타일코드 (style)

  • Key (style_code) — NUMBER — 기본 키 — NOT NULL
  • Field (style_name) — VARCHAR2(30)

유저등급 (account_grade)

  • Key (account_grade_code) — NUMBER — 기본 키 — NOT NULL
  • Field (account_grade_name) — VHARCHAR2(30)

유저별선호스타일 (account_style)

  • userno (account_no) — NUMBER — 외래 키 → 계정필수정보.userno — NOT NULL
  • Key (style_code) — NUMBER — 외래 키 → 스타일코드.Key — NOT NULL

의상분류 (cloth_category)

  • Key (cloth_category_code) — NUMBER — 기본 키 — NOT NULL
  • Field (cloth_category_name) — VARCHAR2(50)

의상정보 (cloth)

  • Key (cloth_code) — NUMBER — 기본 키 — NOT NULL
  • Key (cloth_category_code) — NUMBER — 외래 키 → 의상분류.Key — NOT NULL
  • Field (cloth_name) — VARCHAR2(50)
  • Field (cloth_link_url) — VARCHAR2(255)
  • Field (cloth_gender) — CHAR(1)
  • Field (cloth_img) — VARCHAR2(255)

지역 (location)

  • Key (location_code) — NUMBER — 기본 키 — NOT NULL
  • Field (location_name) — VARCHAR2(255)

쿠키정보 (cookie)

  • Key (cookie_id) — CHAR(8) — 기본 키 — NOT NULL
  • Key (cookie_ip) — VARCHAR2(15) — 기본 키 — NOT NULL
  • userno (account_no) — NUMBER — 외래 키 → 계정필수정보.userno — NOT NULL
  • Field (cookie_last_login) — DATE