alld
Tables (13)
Address (addr)
- Address no (addr_cd) — int — Primary key — NOT NULL
- User no (user_cd) — int — Foreign key → User.User no — NOT NULL
- Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL
- addr code (addr_code) — int — Foreign key → Address code.addr code — NOT NULL
Address code (addr_code)
- addr code (addr_code) — int — Primary key — NOT NULL
Admin (admin)
- adm_cd — int — Primary key — NOT NULL
- User no (user_cd) — int — Foreign key → User.User no — NOT NULL
Delevery (deliver)
- Delevery no (order_cd) — int — Primary key — NOT NULL
- Order no (order_cd2) — int — Foreign key → Order.Order no — NOT NULL
- User no (user_cd) — int — Foreign key → Order.User no — NOT NULL
- Item no (item_cd) — int — Foreign key → Order.Item no — NOT NULL
Ground (ground)
- Ground no (ground_cd) — int — Primary key — NOT NULL
- Main list no (mainlist_cd) — int — Foreign key → Main list.Main list no — NOT NULL
Item (item)
- Item no (item_cd) — int — Primary key — NOT NULL
- Main list no (mainlist_cd) — int — Foreign key → Main list.Main list no — NOT NULL
Item detail (item_detail)
- Item detail no (itm_detail_cd) — int — Primary key — NOT NULL
- Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL
Main list (main_list)
- Main list no (mainlist_cd) — int — Primary key — NOT NULL
Option (option)
- Option no (option_cd) — int — Primary key — NOT NULL
- Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL
Order (order)
- Order no (order_cd) — int — Primary key — NOT NULL
- User no (user_cd) — int — Foreign key → User.User no — NOT NULL
- Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL
Review (review)
- Review no (review_cd) — int — Primary key — NOT NULL
- User no (user_cd) — int — Foreign key → User.User no — NOT NULL
- Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL
Seller (seller)
- Seller no (item_cd) — int — Primary key — NOT NULL
- Order no (order_cd) — int — Foreign key → Order.Order no — NOT NULL
- User no (user_cd) — int — Foreign key → Order.User no — NOT NULL
- Item no (item_cd2) — int — Foreign key → Order.Item no — NOT NULL
User (user)
- User no (user_cd) — int — Primary key — NOT NULL