HappyBox

Tables (41)

TBL_BOARD

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • BOARD_CONTENT — CLOB
  • BOARD_TITLE — VARCHAR2(255 char)

TBL_BOARD_FILE

  • FILE_REPRESENT — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • DONATION_BOARD_ID — NUMBER(19)
  • RECIPE_BOARD_ID — NUMBER(19)
  • REVIEW_BOARD_ID — NUMBER(19)

TBL_DISTRIBUTOR

  • DISTRIBUTOR_NAME — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL

TBL_DONATION_BOARD

  • DONATE_LOCATION — VARCHAR2(255 char)
  • DONATE_TYPE — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • WELFARE_ID — NUMBER(19)

TBL_FILES

  • ID — NUMBER(19) — Primary key — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • FILE_ORG_NAME — VARCHAR2(255 char)
  • FILE_PATH — VARCHAR2(255 char)
  • FILE_UUID — VARCHAR2(255 char)

TBL_FOOD

  • ID — NUMBER(19) — NOT NULL
  • FILE_ORG_NAME — VARCHAR2(255 char)
  • FILE_PATH — VARCHAR2(255 char)
  • FILE_UUID — VARCHAR2(255 char)
  • FOOD_NAME — VARCHAR2(255 char)
  • FOOD_CALENDAR_ID — NUMBER(19)

TBL_FOOD_CALENDAR

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • END_DATE — DATE
  • FOOD_CALENDAR_DESCRIPTION — CLOB
  • FOOD_CALENDAR_TITLE — VARCHAR2(255 char)
  • START_DATE — DATE
  • SUBSCRIPTION_ID — NUMBER(19)

TBL_INQUIRY

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • INQUIRY_CONTENT — CLOB
  • INQUIRY_STATUS — VARCHAR2(255 char)
  • INQUIRY_TITLE — VARCHAR2(255 char)
  • INQUIRY_TYPE — VARCHAR2(255 char)
  • USER_ID — NUMBER(19)

TBL_INQUIRY_ANSWER

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • INQUIRY_ANSWER_CONTENT — CLOB
  • INQUIRY_ID — NUMBER(19)

TBL_INQUIRY_ANSWER_FILE

  • FILE_REPRESENT — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • INQUIRY_ANSWER_ID — NUMBER(19)

TBL_INQUIRY_FILE

  • FILE_REPRESENT — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • INQUIRY_ID — NUMBER(19)

TBL_MEMBER

  • DELIVERY_NAME — VARCHAR2(255 char)
  • DELIVERY_PHONE_NUMBER — VARCHAR2(255 char)
  • MEMBER_BIRTH — DATE
  • ADDRESS_DETAIL — VARCHAR2(255 char)
  • FIRST_ADDRESS — VARCHAR2(255 char)
  • ZIPCODE — VARCHAR2(255 char)
  • MEMBER_GENDER — VARCHAR2(255 char)
  • MEMBER_NAME — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL

TBL_MEMBER_ORDER_PRODUCT

  • PURCHASE_STATUS — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • MEMBER_ID — NUMBER(19)

TBL_MEMBER_ORDER_PRODUCT_ITEM

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • ORDER_AMOUNT — NUMBER(19)
  • ORDER_ID — NUMBER(19)
  • PRODUCT_ID — NUMBER(19)

TBL_NOTICE

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • NOTICE_CONTENT — CLOB
  • NOTICE_TITLE — VARCHAR2(255 char)

TBL_NOTICE_FILE

  • FILE_REPRESENT — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • NOTICE_ID — NUMBER(19)

TBL_ORDER

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • ADDRESS_DETAIL — VARCHAR2(255 char)
  • FIRST_ADDRESS — VARCHAR2(255 char)
  • ZIPCODE — VARCHAR2(255 char)
  • RECEIVER_NAME — VARCHAR2(255 char)
  • RECEIVER_PHONE_NUMBER — VARCHAR2(255 char)

TBL_ORDER_SUBSCRIPTION

  • SUB_OPTION — VARCHAR2(255 char)
  • SUBSCRIPT_STATUS — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • MEMBER_ID — NUMBER(19)
  • SUBSCRIPTION_ID — NUMBER(19)

TBL_PAYMENT

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • PAYMENT_AMOUNT — NUMBER(19)
  • PAYMENT_STATUS — VARCHAR2(255 char)
  • ORDER_ID — NUMBER(19)
  • USER_ID — NUMBER(19)

TBL_PRODUCT

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • PRODUCT_CATEGORY — VARCHAR2(255 char)
  • PRODUCT_INFO — CLOB
  • PRODUCT_LIKE_COUNT — NUMBER(10)
  • PRODUCT_NAME — VARCHAR2(255 char)
  • PRODUCT_ORDER_COUNT — NUMBER(19)
  • PRODUCT_PRICE — NUMBER(10)
  • PRODUCT_REPLY_COUNT — NUMBER(10)
  • PRODUCT_STOCK — NUMBER(19)
  • DISTRIBUTOR_ID — NUMBER(19)

TBL_PRODUCT_CART

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • CART_ORDER_AMOUNT — NUMBER(19)
  • PRODUCT_ID — NUMBER(19)
  • USER_ID — NUMBER(19)

TBL_PRODUCT_FILE

  • FILE_REPRESENT — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • PRODUCT_ID — NUMBER(19)

TBL_PRODUCT_REPLY

  • ID — NUMBER(19) — NOT NULL
  • PRODUCT_ID — NUMBER(19)

TBL_RECIPE_BOARD

  • RECIPE_BOARD_REPLY_COUNT — NUMBER(10)
  • RECIPE_LIKE_COUNT — NUMBER(10)
  • ID — NUMBER(19) — NOT NULL
  • MEMBER_ID — NUMBER(19)

TBL_RECIPE_BOARD_LIKE

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • MEMBER_ID — NUMBER(19)
  • RECIPE_BOARD_ID — NUMBER(19)

TBL_RECIPE_BOARD_REPLY

  • ID — NUMBER(19) — NOT NULL
  • RECIPE_BOARD_ID — NUMBER(19)

TBL_REPLY

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • REPLY_CONTENT — VARCHAR2(255 char)
  • REPLY_LIKE_COUNT — NUMBER(10)
  • USER_ID — NUMBER(19)

TBL_REPLY_LIKE

  • ID — NUMBER(19) — NOT NULL
  • REPLY_ID — NUMBER(19)
  • USER_ID — NUMBER(19)

TBL_REVIEW_BOARD

  • REVIEW_BOARD_REPLY_COUNT — NUMBER(10)
  • REVIEW_LIKE_COUNT — NUMBER(10)
  • REVIEW_RATING — NUMBER(10)
  • WELFARE_NAME — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • MEMBER_ID — NUMBER(19)

TBL_REVIEW_BOARD_LIKE

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • MEMBER_ID — NUMBER(19)
  • REVIEW_BOARD_ID — NUMBER(19)

TBL_REVIEW_BOARD_REPLY

  • ID — NUMBER(19) — NOT NULL
  • REVIEW_BOARD_ID — NUMBER(19)

TBL_RIDER

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • DELIVERY_STATUS — VARCHAR2(255 char)
  • FILE_ORG_NAME — VARCHAR2(255 char)
  • FILE_PATH — VARCHAR2(255 char)
  • FILE_UUID — VARCHAR2(255 char)
  • RIDER_NAME — VARCHAR2(255 char)
  • RIDER_PHONE_NUMBER — VARCHAR2(255 char)
  • WELFARE_ID — NUMBER(19)

TBL_SUBSCRIPTION

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • ORDER_COUNT — NUMBER(19)
  • REVIEW_AVG_RATING — FLOAT
  • REVIEW_COUNT — NUMBER(19)
  • SUBSCRIPT_LIKE_COUNT — NUMBER(10)
  • SUBSCRIPTION_CONTENT — CLOB
  • SUBSCRIPTION_PRICE — NUMBER(10)
  • SUBSCRIPTION_TITLE — VARCHAR2(255 char)
  • WELFARE_ID — NUMBER(19)

TBL_SUBSCRIPTION_CART

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • SUB_OPTION — VARCHAR2(255 char)
  • MEMBER_ID — NUMBER(19)
  • SUBSCRIPTION_ID — NUMBER(19)

TBL_SUBSCRIPT_LIKE

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • MEMBER_ID — NUMBER(19)
  • SUBSCRIPTION_ID — NUMBER(19)

TBL_USER

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • ADDRESS_DETAIL — VARCHAR2(255 char)
  • FIRST_ADDRESS — VARCHAR2(255 char)
  • ZIPCODE — VARCHAR2(255 char)
  • USER_EMAIL — VARCHAR2(255 char)
  • USER_ID — VARCHAR2(255 char)
  • USER_PASSWORD — VARCHAR2(255 char)
  • USER_PHONE_NUMBER — VARCHAR2(255 char)
  • USER_ROLE — VARCHAR2(255 char)
  • USER_STATUS — VARCHAR2(255 char)

TBL_USER_FILE

  • FILE_REPRESENT — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • USER_ID — NUMBER(19)

TBL_USER_RANDOM_KEY

  • ID — NUMBER(19) — NOT NULL
  • RAN_KEY — VARCHAR2(255 char)
  • USER_ID — NUMBER(19)

TBL_WELFARE

  • WELFARE_NAME — VARCHAR2(255 char)
  • WELFARE_POINT_TOTAL — NUMBER(10)
  • ID — NUMBER(19) — NOT NULL

TBL_WELFARE_ORDER_PRODUCT

  • PURCHASE_STATUS — VARCHAR2(255 char)
  • ID — NUMBER(19) — NOT NULL
  • WELFARE_ID — NUMBER(19)

TBL_WELFARE_ORDER_PRODUCT_ITEM

  • ID — NUMBER(19) — NOT NULL
  • CREATED_DATE — TIMESTAMP(6)
  • UPDATED_DATE — TIMESTAMP(6)
  • ORDER_AMOUNT — NUMBER(19)
  • PRODUCT_ID — NUMBER(19)
  • ORDER_ID — NUMBER(19)