DEV
Tables (7)
COM_CD (공통코드)
- UNI_CD (통합코드) — VARCHAR2(6) — Primary key — NOT NULL
- UNI_CD_NM (통합코드명) — VARCHAR2(100)
- CL)UNI_CD (유형통합코드) — VARCHAR2(6)
- SEQ (정렬순서) — NUMBER
- CD_DESC (코드설명) — VARCHAR2(500)
- REG_ID (등록자ID) — VARCHAR2(20)
- REG_DTS (등록일시) — DATE
- MOD_ID (수정자ID) — VARCHAR2(20)
- MOD_DTS (수정일시) — DATE
ITEM (상품)
- ITEM_ID (상품ID) — NUMBER — Primary key
- ITEM_NM (상품명) — VARCHAR2(100)
- ITEM_TYPE (상품구분코드) — VARCHAR2(6)
- SALE_YN (판매여부) — VARCHAR2(1)
- ITEM_DESC (상품설명) — VARCHAR2(500)
- REG_ID (등록자ID) — VARCHAR2(20)
- REG_DTS (등록일시) — DATE
- MOD_ID (수정자ID) — VARCHAR2(20)
- MOD_DTS (수정일시) — DATE
ORD (주문)
- ORD_NO (주문번호) — NUMBER — Primary key — NOT NULL
- SHOP_NO (매장번호) — VARCHAR2(10) — Foreign key → SHOP.SHOP_NO
- ORD_DT (주문일자) — VARCHAR2(8)
- ORD_HMS (주문시간) — VARCHAR2(6)
ORD_ITEM (주문상품)
- ITEM_ID (상품ID) — NUMBER — Foreign key → ITEM.ITEM_ID
- ORD_NO (주문번호) — NUMBER — Foreign key → ORD.ORD_NO — NOT NULL
- SHOP_NO (매장번호) — VARCHAR2(10) — Foreign key → ORD.SHOP_NO
- ORD_ITEM (주문상품수량) — NUMBER
- ORD_DT (주문일자) — VARCHAR(8)
- ORD_HMS (주문시간) — VARCHAR2(6)
SHOP (매장)
- SHOP_NO (매장번호) — VARCHAR2(10) — Primary key
- SHOP_NM (매장명) — VARCHAR2(100)
- ADDR (주소) — VARCHAR2(500)
- TEL (전화번호) — VARCHAR2(20)
- REG_ID (등록자ID) — VARCHAR2(20)
- REG_DTS (등록일시) — DATE
- MOD_ID (수정자ID) — VARCHAR2(20)
- MOD_DTS (수정일시) — DATE
UITEM (단품)
- UITEM_ID (단품ID) — NUMBER — Primary key — NOT NULL
- ITEM_ID (상품ID) — NUMBER — Foreign key → ITEM.ITEM_ID — NOT NULL
- UITEM_NM (단품명) — VARCHAR2(100)
- SALE_YN (판매여부) — VARCHAR2(1)
- UITEM_DESC (단품설명) — VARCHAR2(500)
- REG_ID (등록자ID) — VARCHAR2(20)
- REG_DTS (등록일시) — DATE
- MOD_ID (수정자ID) — VARCHAR2(20)
- MOD_DTS (수정일시) — DATE
UITEM_PRICE (단품가격)
- UITEM_ID (단품ID) — NUMBER — Foreign key → UITEM.UITEM_ID — NOT NULL
- ITEM_ID (상품ID) — NUMBER — Foreign key → UITEM.ITEM_ID
- APPLY_DT (적용일자) — VARCHAR2(8)
- SALE_PRICE (판매가) — NUMBER
- DISCOUNT (할인가) — NUMBER
- COST_PRICE (원가) — NUMBER
- REG_ID (등록자ID) — VARCHAR2(20)
- REG_DTS (등록일시) — DATE
- MOD_ID (수정자ID) — VARCHAR2(20)
- MOD_DTS (수정일시) — DATE