Team_Project

Tables (8)

Admin (관리자)

  • aid (관리자계정) — varchar(100) — Primary key — NOT NULL
  • apw (관리자비밀번호) — varchar(100)
  • aname (관리자이름) — varchar(10)
  • aadd (관리자주소) — varchar(100)
  • aemail (관리자이메일) — varchar(50)
  • atel (관리자전화번호) — varchar(15)

Comment (댓글)

  • cno (댓글번호) — int — Primary key — NOT NULL — auto_increment
  • pno (상품번호) — int
  • writer (작성자) — varchar(100)
  • content (댓글내용) — text
  • creg_date (댓글작성시간) — datetime
  • cmod_date (댓글수정시간) — datetime
  • rate (별점) — int

Consult (상담)

  • csno (상담번호) — int — Primary key — NOT NULL
  • csid (아이디) — varchar(100)
  • cscontent (상담내용) — text
  • csdate (상담시간) — datetime
  • cstype (카테고리) — varchar(100)
  • csname (고객이름) — varchar(100)
  • cstel (고객전화번호) — varchar(100)
  • checked (조회) — varchar(10)

Customer (고객)

  • cid (고객아이디) — varchar(100) — Primary key — NOT NULL
  • cname (고객이름) — varchar(10)
  • cpw (고객비밀번호) — varchar(100)
  • cage (고객나이) — int
  • cgender (고객성별) — varchar(5)
  • cnick_name (고객닉네임) — varchar(10)
  • cemail (고객이메일) — varchar(50)
  • ctel (고객전화번호) — varchar(15)
  • cadd (고객주소) — varchar(100)
  • cdate (생성날짜) — datetime — NOT NULL

File (파일)

  • uuid (고유식별자) — varchar(256) — Primary key — NOT NULL
  • save_dir (파일저장위치) — varchar(256)
  • file_name (파일이름) — varchar(256)
  • file_type (파일타입) — tinyint(1)
  • file_size (파일크기) — int
  • pno (상품번호) — int
  • fileCategoryNum (상품카테고리번호) — int

Product (상품)

  • pno (상품번호) — int — Primary key — NOT NULL — auto_increment
  • type_a (카테고리) — varchar(100)
  • pname (상품이름) — varchar(100)
  • price (상품가격) — int
  • content (제품상세) — text
  • count (재고) — int
  • fileCategoryNum (상품카테고리번호) — int

admin_calendarevent (관리자 예약)

  • event_num (이벤트 넘버) — int — Primary key — auto_increment
  • date (날짜) — date — NOT NULL
  • time (시간) — time — NOT NULL
  • request_term (내용) — text
  • cid (아이디) — varchar(100)
  • status (예약상태) — varchar(50)
  • admin_confirmation (관리자확인) — tinyint(1)
  • type_a (카테고리) — varchar(100)
  • admin_comments (관리자댓글) — text
  • pno (상품번호) — int — Foreign key → Product.pno — NOT NULL — auto_increment
  • cid (고객아이디) — varchar(100) — Foreign key → Customer.cid — NOT NULL

calendarevent (예약)

  • event_num (예약번호) — int — Primary key — auto_increment
  • date (날짜) — date — NOT NULL
  • time (시간) — time — NOT NULL
  • request_term (내용) — text
  • cid (아이디) — varchar(100)
  • status (예약상태) — varchar(50)
  • admin_confirmation (관리자확인) — tinyint
  • type_a (카테고리) — varchar(100)
  • pno (상품번호) — int — Foreign key → Product.pno — NOT NULL — auto_increment
  • cid (고객아이디) — varchar(100) — Foreign key → Customer.cid — NOT NULL