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