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