shop

Tables (9)

Copy Of Copy Of Untitled2 (소)

  • Key (소) — Primary key — NOT NULL
  • Field (카테고리)
  • Key (중) — Foreign key → Copy Of Untitled2.Key — NOT NULL

Copy Of Untitled (판매회원)

  • Key (sell_id) — nvarchar2(30) — Primary key — NOT NULL
  • Field (password) — nvarchar2(30)
  • Field (address) — navrchar2(100)
  • Field (tel) — varchar2(15)
  • Field (계좌번호) — nvarchar2(30)

Copy Of Untitled2 (중)

  • Key (중) — Primary key — NOT NULL
  • Field (카테고리)
  • Key (대) — Foreign key → Untitled.Key — NOT NULL

Untitled (일반회원)

  • Key (id) — nvarchar2(30) — Primary key — NOT NULL
  • Field (password) — nvarchar2(30)
  • Field (address) — navrchar2(100)
  • Field (tel) — varchar2(15)
  • Field (name)

Untitled (판매물)

  • Key (판매id) — nvarchar2(30) — Primary key — NOT NULL
  • Field (판매물 이름) — nvarchar2(30)
  • Key (sell_id) — nvarchar2(30) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (대) — Foreign key → Untitled.Key — NOT NULL
  • Key (중) — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (소) — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Field (가격) — nvarchar2(30)
  • Field (수량)

Untitled (구매)

  • Key (id) — nvarchar2(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (판매id) — nvarchar2(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (구매 날짜) — date
  • Key (sell_id) — nvarchar2(30) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field2 (매출)

Untitled (장바구니)

  • Key (판매id) — nvarchar2(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (수량)
  • Key (id) — nvarchar2(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (대)

  • Key (대) — Primary key — NOT NULL
  • Field (카테고리)

Untitled (구매후기)

  • Key (후기번호) — Primary key — NOT NULL
  • Key (판매id) — nvarchar2(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — nvarchar2(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (후기내용) — nvarchar2(500)
  • Field (날짜) — date