moamz

Tables (31)

FG_BUSINESS (Untitled4)

  • FG_BUSINESS_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_BUSDINESS_PROFILE (Field) — VARCHAR2 — NOT NULL
  • FG_BUSDINESS_OPEN (Field2) — DATE — NOT NULL
  • FG_BUSDINESS_CLOSE (Field3) — DATE
  • FG_BUSDINESS_DETAIL (Field4) — VARCHAR2
  • FG_BUSDINESS_POSTCODE (Field5) — VARCHAR2 — NOT NULL
  • FG_BUSDINESS_ADDRESS (Field6) — VARCHAR2 — NOT NULL
  • FG_BUSINESS_ADDRESS_DETAIL (Field7) — VARCHAR2 — NOT NULL
  • FG_BUSINESS_NUMBER (Field8) — VARCHAR2 — NOT NULL — unique
  • FG_BUSINESS_PHONE (Field9) — VARCHAR2 — NOT NULL
  • FG_BUSINESS_RATING (Field10) — NUMBER — NOT NULL
  • FG_BUSINESS_LIKES (Field11) — NUMBER — NOT NULL
  • FG_USER_CODE (Key2) — NUMBER — Foreign key → FG_SELLER.FG_USER_CODE — NOT NULL

FG_CART (Untitled26)

  • FG_CART_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_USER_CODE (Key2) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL

FG_CART_DETAIL (Untitled27)

  • FG_CART_DETAIL_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_CART_DETAIL_QUANTITY (Field) — NUMBER
  • FG_CART_ID (Key2) — NUMBER — Foreign key → FG_CART.FG_CART_ID — NOT NULL
  • FG_PRODUCT_ID (Key3) — NUMBER — Foreign key → FG_PRODUCT.FG_PRODUCT_ID — NOT NULL

FG_CHAT_MESSAGE (Untitled10)

  • FG_CHAT_MESSAGE_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_MESSAGE_CONTENT (Field) — VARCHAR2
  • FG_SENT_AT (Field2)
  • FG_IS_READ (Field3) — CHAR
  • FG_CHAR_ROOM_ID (Key2) — NUMBER — Foreign key → FG_CHAT_ROOM.FG_CHAR_ROOM_ID — NOT NULL

FG_CHAT_ROOM (Untitled9)

  • FG_CHAR_ROOM_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_CHAT_ROOM_NAME (Field) — VARCHAR2 — NOT NULL
  • Field2
  • FG_SENDER_CODE (Key2) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL
  • FG_RECEIVER_CODE (Key3) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL

FG_COMMENT (Untitled21)

  • FG_COMMENT_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_COMMENT_DATE (Field) — DATE
  • FG_COMMENT_CONTENT (Field2) — VARCHAR2
  • FG_COMMENT_EDIT (Field3) — CHAR
  • FG_POST_ID (Key2) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_USER_CODE (Key3) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL

FG_COMMON_USER (Untitled)

  • FG_USER_CODE (Key) — NUMBER — Primary key — NOT NULL
  • FG_USER_ID (Field2) — VARCHAR2 — NOT NULL — unique
  • FG_USER_PASSWORD (Field) — VARCHAR2
  • FG_USER_TYPE (Field3) — VARCHAR2 — NOT NULL

FG_ECO (Untitled15)

  • FG_POST_ID (Key) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_ECO_START (Field) — DATE — NOT NULL
  • FD_ECO_END (Field2) — DATE — NOT NULL
  • FG_ECO_PARTICIPATION (Field3) — VARCHAR2
  • FG_ECO_INFO (Field4) — VARCHAR2 — NOT NULL
  • FG_CERT_INFO (Field5) — VARCHAR2 — NOT NULL
  • FG_ECO_POINTS (Field6) — NUMBER — NOT NULL
  • FG_ECO_STATUS (Field7) — CHAR
  • FG_FILE_ID (Key3) — NUMBER — Foreign key → FG_POST_FILE.FG_FILE_ID — NOT NULL

FG_ECO_CERT (Untitled16)

  • FG_POST_ID (Key) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_CERT_CONTENT (Field) — VARCHAR2
  • FG_FILE_ID (Key2) — NUMBER — Foreign key → FG_POST_FILE.FG_FILE_ID — NOT NULL
  • FG_POST_ID (Key4) — NUMBER — Foreign key → FG_ECO.FG_POST_ID — NOT NULL

FG_FREE (Untitled20)

  • FG_POST_ID (Key) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_FREE_CONTENT (Field) — CLOB

FG_INQUIRY (Untitled14)

  • FG_POST_ID (Key) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_INQUIRY_CONTENT (Field) — VARCHAR2
  • FG_INQUIRY_STATUS (Field2) — CHAR

FG_LIKE (Untitled5)

  • FG_LIKE_ID (Key) — Primary key — NOT NULL
  • FG_USER_CODE (Key2) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL
  • FG_BUSINESS_ID (Key3) — NUMBER — Foreign key → FG_BUSINESS.FG_BUSINESS_ID — NOT NULL
  • FG_POST)ID (Key4) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL

FG_MAIN_CATEGORY (Untitled23)

  • FG_MAIN_CATEGORY_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_MAIN_CATEGORY_NAME (Field) — VARCHAR2 — NOT NULL

FG_NORMAL_USER (Untitled2)

  • FG_USER_CODE (Key) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL
  • FG_NORMAL_PROFILE (Field) — VARCHAR2 — NOT NULL
  • FG_NORMAL_NAME (Field2) — VARCHAR2 — NOT NULL
  • FG_NORMAL_PHONE (Field3) — VARCHAR2 — unique
  • FG_NORMAL_NICKNAME (Field4) — VARCHAR2 — NOT NULL — unique
  • FG_NORMAL_BIRTH (Field5) — DATE
  • FG_NORMAL_GENDER (Field6) — VARCHAR2
  • FG_NORMAL_POSTCODE (Field7) — VARCHAR2 — NOT NULL
  • FG_NORMAL_ADDRESS (Field8) — VARCHAR2 — NOT NULL
  • FG_NORMAL_ADDRESS_DETAIL (Field9) — VARCHAR2 — NOT NULL
  • FG_NORMAL_LOGIN_TYPE (Field10) — VARCHAR2 — NOT NULL
  • FG_KAKAO_ID (Field11) — VARCHAR2

FG_NOTICE (Untitled13)

  • FG_POST_ID (Key3) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_NOTICE_CONTENT (Field) — VARCHAR2

FG_ORDER (Untitled28)

  • FG_ORDER_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_ORDER_AMOUNT (Field) — NUMBER — NOT NULL
  • FG_ORDER_STATUS (Field2) — VARCHAR2
  • FG_ORDER_POINTS_USED (Field3) — NUMBER
  • FG_USER_CODE (Key2) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL

FG_ORDER_PRODUCT (Untitled29)

  • FG_ORDER_PRODUCT_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_ORDER_PRODUCT_QUANTITY (Field) — NUMBER
  • FG_ORDER_PRODUCT_PRICE (Field2) — NMBER
  • FG_ORDER_ID (Key2) — NUMBER — Foreign key → FG_ORDER.FG_ORDER_ID — NOT NULL
  • FG_PRODUCT_ID (Key3) — NUMBER — Foreign key → FG_PRODUCT.FG_PRODUCT_ID — NOT NULL

FG_PAYMENT (Untitled31)

  • FG_PAYMENT_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_PAYMENT_AMOUNT (Field) — NUMBER — NOT NULL
  • FG_PAYMENT_DATE (Field2) — DATE
  • FG_PAYMENT_TRANSACTION_ID (Field3) — VARCHAR2
  • FG_PAYMENT_STATUS (Field4) — VARCHAR2
  • FG_PAYMENT_TAX (Field5) — NUMBER
  • FG_ORDER_ID (Key2) — NUMBER — Foreign key → FG_ORDER.FG_ORDER_ID — NOT NULL

FG_PICKUP (Untitled30)

  • FG_PICKUP_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_PICKUP_SCHEDULE (Field) — VARCHAR2
  • FG_PICKUP_COMPLETED (Field2) — VARCHAR2
  • FG_PICKUP_REQUEST (Field3) — VARCHAR2
  • FG_PICKUP_STATUS (Field4) — VARCHAR2
  • FG_ORDER_ID (Key2) — NUMBER — Foreign key → FG_ORDER.FG_ORDER_ID — NOT NULL

FG_POINT (Untitled6)

  • FG_POINT_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_POINT_TOTAL (Field) — NUMBER
  • FG_CARBON_REDUCTION (Field2) — NUMBER
  • FG_POINT_DETAIL_ID (Key2) — NUMBER — Foreign key → FG_POINT_DETAIL.FG_POINT_DETAIL_ID — NOT NULL
  • FG_USER_CODE (Key3) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL

FG_POINT_DETAIL (Untitled7)

  • FG_POINT_DETAIL_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_POINT_DATE (Field) — DATE
  • FG_POINT_RECEIVED (Field2) — NUMBER
  • FG_POINT_USER (Field3) — NUMBER

FG_POST (Untitled11)

  • FG_POST_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_POST_TYPE (Field) — VARCHAR2
  • FG_POST_CREATEDAT (Field2) — DATE
  • FG_POST_LIKES (Field3) — NUMBER
  • FG_POST_VIEWS (Field4) — NUMBER
  • FG_USER_CODE (Key2) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL

FG_POST_FILE (Untitled12)

  • FG_FILE_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_FILE_NAME (Field) — VARCHAR2 — NOT NULL
  • FG_FILE_URL (Field2) — VARCHAR2 — NOT NULL
  • FG_FILE_UUID (Field3) — VARCHAR2 — NOT NULL
  • FG_POST_ID (Key2) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL

FG_PRODUCT (Untitled22)

  • FG_PRODUCT_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_PRODUCT_NAME (Field) — VARCHAR2 — NOT NULL
  • FG_PRODUCT_PRICE (Field2) — NUMBER — NOT NULL
  • FG_PRODUCT_STOCK (Field3) — NUMBER — NOT NULL
  • FG_PRODUCT_WEIGHT (Field4) — NUMBER
  • FG_PRODUCT_EXP_DATE (Field5) — DATE — NOT NULL
  • FG_PRODUCT_CONTENT (Field6) — VARCHAR2 — NOT NULL
  • FG_PRODUCT_STATUS ("판매중", "판매완료") — VARCHAR2
  • FG_BUSINESS_ID (Key2) — NUMBER — Foreign key → FG_BUSINESS.FG_BUSINESS_ID — NOT NULL
  • FG_SUB_CATEGORY_ID (Key3) — NUMBER — Foreign key → FG_SUB_CATEGORY.FG_SUB_CATEGORY_ID — NOT NULL
  • FG_PRODUCT_FILE_ID (Key4) — NUMBER — Foreign key → FG_PRODUCT_FILE.FG_PRODUCT_FILE_ID — NOT NULL

FG_PRODUCT_FILE (Untitled25)

  • FG_PRODUCT_FILE_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_PRODUCT_FILE_NAME (Field) — VARCHAR2
  • FG_PRODUCT_FILE_URL (Field2) — VARCHAR2
  • FG_PRODUCT_FILE_UUID (Field3) — VARCHAR2

FG_RECEIPE (Untitled18)

  • FG_POST_ID (Key2) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_RECEIPE_INGREDIENTS (Field) — VARCHAR2 — NOT NULL
  • FG_RECEIPE_TIME (Field2) — VARCHAR2 — NOT NULL
  • FG_RECEIPE_CONTENT (Field3) — CLOB — NOT NULL
  • FG_FILE_ID (Key) — NUMBER — Foreign key → FG_POST_FILE.FG_FILE_ID — NOT NULL

FG_REVIEW (Untitled8)

  • FD_REVIEW_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_REVIEW_RATING (Field) — NUMBER — NOT NULL
  • FG_REVIEW_CONTENT (Field2) — VARCHAR2 — NOT NULL
  • FG_USER_CODE (Key2) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL
  • FG_BUSINESS_ID (Key3) — NUMBER — Foreign key → FG_BUSINESS.FG_BUSINESS_ID — NOT NULL
  • FG_CREATEDAT (Field3) — DATE

FG_SELLER (Untitled3)

  • FG_USER_CODE (Key) — NUMBER — Foreign key → FG_COMMON_USER.FG_USER_CODE — NOT NULL
  • FG_SELLER_NAME (Field) — VARCHAR2 — NOT NULL
  • FG_SELLER_PHONE (Field2) — VARCHAR2 — NOT NULL — unique
  • FG_BUSINESS_ID (Key2) — NUMBER — Foreign key → FG_BUSINESS.FG_BUSINESS_ID — NOT NULL

FG_SHARING (Untitled19)

  • FG_POST_ID (Key) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL
  • FG_SHARING_CONTENT (Field) — CLOB — NOT NULL
  • FG_SHARING_STATUS (Field2) — VARCHAR2

FG_SOCIALING (Untitled17)

  • FG_SOCIALING_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_SOCIALING_CATEGORY (Field) — VARCHAR2
  • FG_SOCIALING_MAX_PARTICIPANTS (Field2) — NUMBER
  • FG_SOCIALING_START (Field3) — DATE
  • FG_SOCIALING_END (Field4) — DATE
  • FG_SOCIALING_LOCATION (Field5) — VARCHAR2
  • FG_SOCIALING_GENDER_RES (Field6) — VARCHAR2
  • FG_SOCIALING_MINAGE (Field7) — NUMBER
  • FG_SOCIALING_MAXAGE (Field8) — NUMBER
  • FG_SOCIALING_CONTENT (Field9) — VARCHAR2
  • FG_FILE_ID (Key2) — NUMBER — Foreign key → FG_POST_FILE.FG_FILE_ID — NOT NULL
  • FG_POST_ID (Key3) — NUMBER — Foreign key → FG_POST.FG_POST_ID — NOT NULL

FG_SUB_CATEGORY (Untitled24)

  • FG_SUB_CATEGORY_ID (Key) — NUMBER — Primary key — NOT NULL
  • FG_SUB_CATEGORY_NAME (Field) — VARCHAR2
  • FG_MAIN_CATEGORY_ID (Key2) — NUMBER — Foreign key → FG_MAIN_CATEGORY.FG_MAIN_CATEGORY_ID — NOT NULL