멍하냥
테이블 (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