멍하냥

테이블 (16)

Address (address)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (seq2) — not null — 외래 키 → USER.Key — NOT NULL
  • Field (addressname) — not null
  • Field (address) — not null
  • Field (receiveuser) — not null
  • Field (receivephone) — not null

Animalprofile (animalprofile)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Field (photo)
  • Field2 (neuter) — not null
  • Field3 (weight) — not null
  • Field (name) — not null
  • Field (breed) — not null
  • Field (gender) — not null
  • Field (birth) — not null
  • Field (content)

Cart (cart)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (productid) — not null — 외래 키 → Product.Key — NOT NULL
  • Field (quantity) — not null
  • Field (status) — not null

Chat (chat)

  • Key — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Field (cdate) — not null

Comment (comment)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (photoid) — not null — 외래 키 → Photo.Key — NOT NULL
  • Key (productid) — not null — 외래 키 → Product.Key — NOT NULL
  • Key (seq32) — 외래 키 → Comment.Key — NOT NULL
  • Field (file)
  • Field (refuser)
  • Field (cdate) — not null
  • Field (content) — not null
  • Field (star)

Follow (follow)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (follow_give) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (follow_recv) — not null — 외래 키 → USER.Key — NOT NULL

Hashtag (hashtag)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (photoid) — not null — 외래 키 → Photo.Key — NOT NULL
  • Field (content) — not null

Likes (likes)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (photoid) — not null — 외래 키 → Photo.Key — NOT NULL
  • Key (commentid) — not null — 외래 키 → Comment.Key — NOT NULL
  • Key (productid) — not null — 외래 키 → Product.Key — NOT NULL
  • Field

Message (message)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (chatid) — not null — 외래 키 → Chat.Key — NOT NULL
  • Field (content)
  • Field (file)
  • Field (readed) — not null
  • Field (wdate) — not null

Orders (orders)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (addressid) — not null — 외래 키 → Address.Key — NOT NULL
  • Field (productamount) — not null
  • Field (deleveryamount) — not null
  • Field (totalamount) — not null
  • Field (usemungpoint) — not null
  • Field (savemungpoint) — not null
  • Field (orderstatus) — not null
  • Field (created) — not null

OrdersDetail (ordersdetail)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (productid) — not null — 외래 키 → Product.Key — NOT NULL
  • Key (addressid) — not null — 외래 키 → Address.Key — NOT NULL
  • Key (orderid) — not null — 외래 키 → Orders.Key — NOT NULL
  • Field (selection) — not null
  • Field (price) — not null
  • Field (quantity) — not null
  • Field (reviewstatus) — not null

Photo (photo)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (userid) — not null — 외래 키 → USER.Key — NOT NULL
  • Key (productid) — 외래 키 → Product.Key — NOT NULL
  • Key (catecode) — primary — 외래 키 → Product.Key — NOT NULL
  • Field (file) — not null
  • Field (content)
  • Field (created) — not null
  • Field (p_link)
  • Field (updated)

Product (product)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (catecode) — not null — 외래 키 → Product_Category.Key — NOT NULL
  • Field (name) — not null
  • Field (thumbnail) — not null
  • Field (content) — not null
  • Field (price) — not null
  • Field (created) — not null
  • Field (del) — not null
  • Field (discount) — not null
  • Field (readcount)
  • Field

Product_Category (product_category)

  • Key (catecode) — primary — 기본 키 — NOT NULL
  • Field (catename) — not null
  • Key (catecoderef) — 외래 키 → Product_Category.Key — NOT NULL

Product_Option (product_option)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Key (productid) — not null — 외래 키 → Product.Key — NOT NULL
  • Field (title) — not null
  • Field (subtitle) — not null
  • Field (optionprice)

USER (user)

  • Key (seq) — primary — 기본 키 — NOT NULL
  • Field (email) — not null unique
  • Field2 (pwd)
  • Field3 (nickname) — not null unique
  • Field (cdate) — not null
  • Field (mungpoint) — not null
  • Field (avatar)
  • Field (sns_onlyb) — not null
  • Field (auth) — not null