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