jjunpro-db

Tables (8)

ACCOUNT (유저정보)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • ip (IP) — VARCHAR-NOT NULL
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP-NOT NULL
  • email (EMAIL) — VARCHAR-UNIQUE
  • password (PASSWORD) — VARCHAR
  • username (USERNAME) — VARCHAR
  • enabled (ENABLED) — BOOLEAN
  • userrole (USERROLE) — VARCHAR
  • agerange (AGERANGE) — VARCHAR
  • birthday (BIRTHDAY) — VARCHAR
  • gender (GENDER) — SMALLINT
  • postcode (POSTCODE) — VARCHAR
  • addr1 (ADDR1) — VARCHAR
  • addr2 (ADDR2) — VARCHAR
  • phonenumber (PHONENUMBER) — VARCHAR-NOT NULL-UNIQUE

DELIVERY (배송관련)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • deliveryName (Field6) — VARCHER
  • deliveryType (Field) — SMALLINT
  • deliveryPayType (Field2) — SMALLINT
  • deliveryDefaultPay (Field3) — SMALLINT
  • deliveryIfPay (Field4) — SMALLINT
  • deliveryQuantityPay (Field5) — SMALLINT

FILE (파일)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • Field

PRODUCT (상품)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • shop_group_ids (SHOP_GROUP_ID) — VARCHAR — Foreign key → SHOP_GROUP.id — NOT NULL
  • file_id (FILE_ID) — Foreign key → FILE.id — NOT NULL
  • sub_item_id (SUB_ITEM_ID) — SERIAL-PRIMARY KEY — Foreign key → SUB_PRODUCT.id — NOT NULL
  • shop_group_id (SHOP_GROUP_ID2) — SERIAL-PRIMARY KEY — Foreign key → SUB_PRODUCT.shop_group_id — NOT NULL
  • file_id (FILE_ID2) — Foreign key → SUB_PRODUCT.file_id — NOT NULL
  • sub_item_id (SUB_ITEM_ID2) — SERIAL-PRIMARY KEY — Foreign key → SUB_PRODUCT.sub_item_id — NOT NULL
  • delivery_id (ID3) — SERIAL-PRIMARY KEY — Foreign key → DELIVERY.id — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • productName (NAME) — VARCHAR
  • explanation (EXPLANATION) — VARCHAR
  • tag (TAG) — VARCHAR
  • productType (TYPE) — VARCHAR
  • callQuestion (CALLQUESTION) — BOOLEAN
  • cuponEnabled (CUPONENABLED) — BOOLEAN
  • pointEnabled (POINTENABLED) — BOOLEAN
  • contentPc (CONTENTPC) — VARCHAR
  • summaryInfo (SUMMARYINFO) — VARCHAR
  • price (PRICE) — INTERGER
  • discount (DISCOUNT) — SMALLINT
  • point (POINT) — INTERGER
  • quantity (QUANTITY) — INTERGER
  • buyMinQuantity (BUYMINQUANTITY) — INTEGER
  • buyMaxQuantity (BUYMAXQUANTITY) — INTEGER
  • reviewState (REVIEWSTATE) — BOOLEAN
  • reservationSale (RESERVATIONSALE) — TIMESTAMP
  • endSale (ENDSALE) — TIMESTAMP
  • priority (PRIORITY) — INTEGER

PRODUCT_ORDER (상품 구매 주문서)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • product_id (ID2) — SERIAL-PRIMARY KEY — Foreign key → PRODUCT.id — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • state (Field) — SMALLINT
  • orderName (Field2) — VARCHAR
  • orderEmail (Field3) — VARCHAR
  • orderPhone (Field4) — VARCHAR
  • postcode (Field5) — VARCHAR
  • addr1 (Field6) — VARCHAR
  • addr2 (Field7) — VARCHAR
  • memo (Field8) — VARCHAR
  • payment (Field9) — SMALLINT
  • cupon (Field10) — VARCHAR
  • point (Field11) — INTEGER

SHOP_GROUP (소분류 노드)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • shopName (NAME) — VARCHAR
  • priority (PRIORITY) — INTERGER — enabled # 뷰 트리에 표시를 할 지 안할 지, 비활성화 된 경우 해당 그룹 내에 있는 제품들은 전부 숨겨짐 name # 분류의 이름 priority # 분류 표시 우선도 (낮을수록 위) shop_group_…
  • parentShopGroupId (Field) — id

SUB_PRODUCT (상품옵션)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • id (ID2) — SERIAL-PRIMARY KEY — Foreign key → PRODUCT.id — NOT NULL
  • shop_group_id (SHOP_GROUP_ID) — SERIAL-PRIMARY KEY — Foreign key → PRODUCT.shop_group_ids — NOT NULL
  • file_id (FILE_ID) — Foreign key → PRODUCT.file_id — NOT NULL
  • sub_item_id (SUB_ITEM_ID) — SERIAL-PRIMARY KEY — Foreign key → PRODUCT.sub_item_id — NOT NULL
  • id (ID3) — SERIAL-PRIMARY KEY — Foreign key → PRODUCT.delivery_id — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • productName (Field) — VARCHER
  • price (PRICE) — INTERGER
  • quantity (QUANTITY) — INTERGER

default (table 기본값)

  • id (ID) — SERIAL-PRIMARY KEY — Primary key — NOT NULL
  • ip (IP) — VARCHAR
  • createddate (CREATEDDATE) — TIMESTAMP-NOT NULL
  • modifieddate (MODIFIEDDATE) — TIMESTAMP
  • enabled (ENABLED) — BOOLEAN
  • Field