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