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)