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)