imWebParty
Tables (6)
MEM_INFO (Untitled)
- ID — VARCHAR2 (20) — Primary key — NOT NULL
- PWD (Password) — VARCHAR2 (20)
- NAME (-) — VARCHAR2 (10)
- REG_NO (Resident Registration Number) — VARCHAR2 (8)
- GENDER (--) — VARCHAR2 (10)
- PHONE_NO (Phone Number) — VARCHAR2 (20)
- HOME_ADDR (Home Address) — VARCHAR2(200)
ORDER (Untitled2)
- ID (Identification) — VARCHAR2 (20) — Primary key — NOT NULL
- PRD_NO (Product Number) — VARCHAR2 (20) — Foreign key → MEM_INFO.ID — NOT NULL
- DEST_ADDR (Destination Address) — VARCHAR2 (100)
- ORD_DATE (Order Date) — SYSDATE
PRD_CLOTH_INFO (Untitled3)
- PRD_NO (Product Number) — VARCHAR2 (50) — Primary key — NOT NULL
- NAME (-) — VARCHAR2 (20)
- PRICE (--) — VARCHAR2 (20)
- LIKES (좋아요 수) — INT (5)
- DC_YN (Discount Yes No) — VARCHAR2 (3)
PRD_CLOTH_INFO_DETAIL (CopyOfCopyOfUntitled4)
- PRD_NO (Product Number) — VARCHAR(20) — Primary key — NOT NULL
- PRD_NO (Product Number2) — VARCHAR2 (50) — Foreign key → PRD_CLOTH_INFO.PRD_NO — NOT NULL
- NAME (-) — VARCHAR2 (20)
- PRICE (--) — VARCHAR2 (20)
- LIKES (좋아요 수) — INT (5)
- DC_YN (Discount Yes No) — VARCHAR2 (3)
- COMPANY (Field) — VARCHAR2 (50)
- COMP_PHONE_NO (Company Phone Number) — VARCHAR2 (20)
- CUMCUL_SALES (Cumulative Sales) — VARCHAR2 (100)
- SIZE (Field2) — INT (3)
- Field3
PRD_PC_INFO (Untitled4)
- PRD_NO (Product Number) — VARCHAR(20) — Primary key — NOT NULL
- ID (Identification) — VARCHAR2 (20) — Foreign key → ORDER.ID — NOT NULL
- PRD_NO (Product Number2) — VARCHAR2 (20) — Foreign key → ORDER.PRD_NO — NOT NULL
- NAME (-) — VARCHAR2 (20)
- PRICE (--) — VARCHAR2 (20)
- LIKES (좋아요 수) — INT (5)
- DC_YN (Discount Yes No) — VARCHAR2 (3)
- Field
PRD_PC_INFO_DETAIL (CopyOfUntitled4)
- PRD_NO (Product Number) — VARCHAR(20) — Primary key — NOT NULL
- PRD_NO (Product Number2) — VARCHAR(20) — Foreign key → PRD_PC_INFO.PRD_NO — NOT NULL
- ID (Identification) — VARCHAR2 (20) — Foreign key → PRD_PC_INFO.ID — NOT NULL
- PRD_NO (Product Number22) — VARCHAR2 (20) — Foreign key → PRD_PC_INFO.PRD_NO — NOT NULL
- NAME (-) — VARCHAR2 (20)
- PRICE (--) — VARCHAR2 (20)
- LIKES (좋아요 수) — INT (5)
- DC_YN (Discount Yes No) — VARCHAR2 (3)
- COMPANY (Field) — VARCHAR2 (50)
- COMP_PHONE_NO (Company Phone Number) — VARCHAR2 (20)
- CUMCUL_SALES (Cumulative Sales) — VARCHAR2 (100)
- SIZE (Field2) — INT (3)
- Field3