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