1234

테이블 (9)

게시글 (post)

  • post_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — VARCHAR2(20) — 기본 키 — NOT NULL
  • post_content (Field) — VARCHAR2(1000)
  • post_title (Field2) — VARCHAR2(100)

댓글 (comment)

  • comment_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Field4) — VARCHAR2(20) — 기본 키
  • comment_content (Field) — VARCHAR2(1000)
  • comment_title (Field2) — VARCHAR2(100)
  • comment_grade (Field3) — VARCHAR2(50)

배송 (address)

  • delivery_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Field) — VARCHAR2(20)
  • city_name (Field2) — VARCHAR2(20)
  • address_id (Field3) — VARCHAR2(20)
  • delivery_status (Field4) — VARCHAR2(20)
  • delivery_nation (Field5) — VARCHAR2(20)

사이즈 (size)

  • size_id (Key) — int — 기본 키 — NOT NULL
  • size_name (Field2) — VARCHAR2(20)

상품 (product)

  • product_id (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • product_name (Field) — VARCHAR2(20)
  • category_id (Field2) — VARCHAR2(20) — NOT NULL
  • product_price (Field3) — VARCHAR2(50)
  • product_info (Field4) — VARCHAR2(1000)
  • product_quantity (Field5) — int
  • product_image (Field6) — VARCHAR2(1000)

성별 (gender)

  • gender_id (Key) — int — 기본 키 — NOT NULL
  • gender_name (Field) — VARCHAR2(20)

장바구니 (basket)

  • cart_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — VARCHAR2(20) — 기본 키 — NOT NULL
  • cart_item (Field2) — VARCHAR2(50)

카테고리 (category)

  • category_id (Key) — int — 기본 키 — NOT NULL
  • product_id (Key2) — VARCHAR2(20) — 기본 키 — NOT NULL
  • category_name (Field) — VARCHAR2(50)
  • gender_id (Field2) — VARCHAR2(20)
  • product_kind (Field3) — VARCHAR2(20)
  • category_kind (Field4) — VARCHAR2(20)

회원 (user)

  • user_num (Key) — int — 기본 키 — NOT NULL
  • user_id (Key3) — VARCHAR2(20) — 기본 키 — NOT NULL
  • user_pw (Field2) — VARCHAR2(20) — NOT NULL
  • user_name (Field3) — VARCHAR2(20)
  • user_email (Field) — VARCHAR2(100)
  • user_phone (Field5) — int
  • gender_id (Key2) — int — NOT NULL