YORIZORI_2
Tables (10)
BROADCAST
- BROADCAST_NO — NUMBER — Foreign key → BROADCAST_RESERVATION.BROADCAST_NO — NOT NULL
- BROADCAST_CONTENT — VARCHAR2(4000)
- BROADCAST_REGDATE — DATE
- BROADCAST_VIEWCOUNT — NUMBER
- MEMBER_ID — VARCHAR2(20) — NOT NULL
BROADCAST_RESERVATION
- BROADCAST_NO — NUMBER — Primary key — NOT NULL
- RESERVATION_TIME — DATE
- RESERVATION_CONFIRM — VARCHAR2(10)
- MEMBER_ID — VARCHAR2(20) — NOT NULL
CATE_FOOD
- CATE_FOOD_NO — NUMBER — Primary key — NOT NULL
- CATE_FOOD_NAME — VARCHAR2(200)
CATE_THEME
- CATE_THEME_NO — NUMBER — Primary key — NOT NULL
- CATE_THEME_NAME — VARCHAR2(200)
GOODS
- GOODS_NO — NUMBER — Primary key — NOT NULL
- GOODS_TITLE — VARCHAR2(50)
- GOODS_PRICE — NUMBER
- GOODS_QUANTITY — NUMBER
- GOODS_CONTENT — VARCHAR2(4000)
- GOODS_REGDATE — DATE
- GOODS_READCOUNT — NUMBER
- MEMBER_ID — VARCHAR2(20) — NOT NULL
- GOODS_PHOTO — VARCHAR2(4000)
GOODS_RE
- GOODS_RE_NO — NUMBER — Primary key — NOT NULL
- GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO — NOT NULL
- GOODS_RE_CONTENT — VARCHAR2(1000)
- GOODS_RE_REGDATE — DATE
- GOODS_RE_GROUPNO — NUMBER
- GOODS_RE_SEQ — NUMBER
- GOODS_RE_TITLETAB — NUMBER
- MEMBER_ID — VARCHAR2(20) — NOT NULL
MEMBER
- MEMBER_ID — VARCHAR2(20) — Primary key — NOT NULL
- MEMBER_PW — VARCHAR2(30)
- MEMBER_NAME — VARCHAR2(50)
- MEMBER_NICK — VARCHAR2(20)
- MEMBER_BIRTH — NUMBER
- MEMBER_EMAIL — VARCHAR2(100)
- MEMBER_PHONE — VARCHAR2(100)
- MEMBER_ENABLED — VARCHAR2(2)
- MEMBERADDR_ADDR — VARCHAR2(50)
- MEMBER_ROLE — VARCHAR2(20)
RECIPE
- RECIPE_NO — NUMBER — Primary key — NOT NULL
- RECIPE_MAIN_PHOTO — VARCHAR2(4000)
- RECIPE_TITLE — VARCHAR2(100)
- RECIPE_CONTENT — VARCHAR2(4000)
- RECIPE_REGDATE — DATE
- RECIPE_READCOUNT — NUMBER
- RECIPE_LIKECOUNT — NUMBER
- RECIPE_MATERIAL_ONE — VARCHAR2(50)
- RECIPE_MATERIAL — VARCHAR2(1000)
- MEMBER_ID — VARCHAR2(20) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
RECIPE_RE
- RECIPE_RE_NO — NUMBER — Primary key — NOT NULL
- RECIPE_NO — NUMBER — Foreign key → RECIPE.RECIPE_NO — NOT NULL
- RECIPE_RE_CONTENT — VARCHAR2(50)
- RECIPE_RE_REGDATE — DATE
- RECIPE_RE_GROUPNO — NUMBER
- RECIPE_RE_SEQ — NUMBER
- RECIPE_RE_TITLETAB — NUMBER
- MEMBER_ID — VARCHAR2(20) — NOT NULL
REFRIGERATOR
- REFRIGERATOR_NO — NUMBER — Primary key — NOT NULL
- REFRIGERATOR_MATERIAL — VARCHAR2(4000)
- MEMBER_ID — VARCHAR2(20) — NOT NULL