1

Tables (6)

Center (센터)

  • VARCHAR(30) (CEN_NAME) — PK — Primary key — NOT NULL
  • VARCHAR(70) (CEN_LOCATION)
  • VARCHAR(15) (CEN_ING)

ClinetSound (Untitled2)

  • INT(200) (MEM_SEQ) — PK — Foreign key → Member.INT(200) — NOT NULL
  • VARCHAR(50) (TITLE)
  • DATETIME (CLI_DATE)
  • INT(500) (HIT)
  • VARCHAR(2000) (CLI_CONTENT)

Member (회원)

  • INT(200) (MEM_SEQ) — PK — Primary key — NOT NULL
  • VARCHAR(30) (PW) — NOT NULL
  • VARCHAR(50) (EMAIL)
  • VARCHAR(20) (PHONE)
  • VARCHAR(20) (NAME)
  • VARCHAR(10) (ROLE)
  • VARCHAR(30) (USERID)
  • VARCHAR(30) (ADDRESS)
  • INT(100) (AS_NUM)
  • INT(100) (AS_PRICE)
  • INT(100) (ORDER_COUNT)
  • INT(100) (TOTALPRICE)

Order (Untitled)

  • INT(200) (ORD_SEQ) — PK — Primary key — NOT NULL
  • DATETIME (ORD_DATE)
  • INT(200) (MEM_SEQ) — FK — Foreign key → Member.INT(200) — NOT NULL
  • INT(100) (ORD_PRICE)
  • INT(100) (ORD_COUNT)
  • VARCHAR(30) (DELIVERY_STATUS)
  • DATETIME (DELIVERY_START)
  • DATETIME (DELIVERY_END)

OrderItem (판매소모품)

  • VARCHAR(30) (ITEM_NAME)
  • VARCHAR(50) (ITEM_CON)
  • VARCHAR(20) (ITEM_CATEGORY)
  • INT(100) (ITEM_PRICE)
  • INT(100) (ITEM_AMOUNT)
  • INT(200) (ORD_SEQ2) — FK — Foreign key → Order.INT(200) — NOT NULL

Reservation (예약)

  • INT(100) (RES_SEQ) — PK — Primary key — NOT NULL
  • VARCHAR(30) (MODEL_NAME)
  • VARCHAR(300) (MODEL_SYMPTOM)
  • DATETIME (RES_DATE)
  • INT(200) (MEM_SEQ) — FK — Foreign key → Member.INT(200) — NOT NULL
  • VARCHAR(30) (CEN_NAME) — FK — Foreign key → Center.VARCHAR(30) — NOT NULL
  • DATETIME (REPAIR_DATE)
  • VARCHAR(50) (REPAIR_CON)
  • INT(100) (REPAIR_PRICE)