JAVA

Tables (6)

memo (캘린더메모)

  • id (memo_id) — int(11) — Primary key — NOT NULL
  • date (날짜) — date — NOT NULL
  • text (내용) — text
  • created_at (작성시간) — timestamp — NOT NULL

nchild (배송전 어린이)

  • id (nchild_id) — int(11) — Primary key — NOT NULL
  • name (이름) — varchar(100) — NOT NULL
  • gender (성별) — enum('Male', 'Female') — NOT NULL
  • age (나이) — enum('4', '5', '6', '7') — NOT NULL
  • address (주소) — varchar(255) — NOT NULL
  • wish_gift (받고싶은 선물) — varchar(255) — NOT NULL

ngift (품절 상품)

  • gift_id — int(11) — Primary key — NOT NULL
  • gift_name (상품명) — varchar(255) — NOT NULL
  • price (가격) — decimal(10,2) — NOT NULL
  • color (색상) — varchar(50) — NOT NULL
  • Field

santa (산타)

  • id (santa_id) — int(11) — Primary key — NOT NULL
  • category (카테고리) — varchar(255) — NOT NULL
  • profile_image (프로필이미지) — text
  • name (산타이름) — varchar(255) — NOT NULL
  • characteristics (특징) — text
  • hobbies (취미) — text

ychild (배송완료 어린이)

  • id (nchild_id) — int(11) — Primary key — NOT NULL
  • name (이름) — varchar(100) — NOT NULL
  • gender (성별) — enum('Male', 'Female') — NOT NULL
  • age (나이) — enum('4', '5', '6', '7') — NOT NULL
  • address (주소) — varchar(255) — NOT NULL
  • wish_gift (받고싶은 선물) — varchar(255) — NOT NULL

ygift (주문가능 상품)

  • gift_id — int(11) — Primary key — NOT NULL
  • gift_name (상품명) — varchar(255) — NOT NULL
  • price (가격) — decimal(10,2) — NOT NULL
  • color (색상) — varchar(50) — NOT NULL
  • Field