test
Tables (45)
adminlog
- id — int(11) — Primary key — NOT NULL
- contentType — int(11) — NOT NULL
- actionType — int(11) — NOT NULL
- beforeData — text
- afterData — text
- adminId — int(11) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
appendtype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
areatype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
avatarpartscolortype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
avatarpartsdivisiontype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
avatarpartsgrouptype
- type — int(11) — Primary key — NOT NULL
- name — varchar(64)
avatarpartsprice
- partsId — int(11) — Primary key — NOT NULL
- arwPrice — int(11) — NOT NULL
- krwPrice — int(11) — NOT NULL
avatarpartssizedetail
- id — int(11) — Primary key — NOT NULL
- sizeType — int(11) — Foreign key → avatarpartssizetype.type — NOT NULL
- data — varchar(20) — NOT NULL
avatarpartssizetype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
avatarpartsstatetype
- type — int(11) — Primary key — NOT NULL
- name — varchar(64) — NOT NULL
avatarpartstype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
avatarpreset
- presetType — int(11) — Foreign key → avatarpresettype.type — NOT NULL
- partsType — int(11) — Foreign key → avatarpartstype.type — NOT NULL
- itemId — int(11) — NOT NULL
avatarpresettype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
avatarresetinfo
- partsType — int(11) — Foreign key → avatarpartstype.type — NOT NULL
- itemId — int(11) — NOT NULL
blockmember
- memberId — varchar(100) — Primary key — NOT NULL
- blockMemberId — varchar(100) — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
booleantype
- type — int(11) — Primary key — NOT NULL
- name — tinyint(1) — NOT NULL
businesscardtemplate
- id — int(11) — Primary key — NOT NULL
- description — varchar(64) — NOT NULL
- purchaseType — int(11) — NOT NULL
- price — int(11) — NOT NULL
- nameField — int(11) — NOT NULL
- phoneField — int(11) — NOT NULL
- emailField — int(11) — NOT NULL
- faxField — int(11) — NOT NULL
- addrField — int(11) — NOT NULL
- jobField — int(11) — NOT NULL
- positionField — int(11) — NOT NULL
- introField — int(11) — NOT NULL
- thumbnailName — varchar(64)
categorytype
- type — int(11) — Primary key — NOT NULL
- name — varchar(64)
commercezoneitem
- itemId — int(11) — Primary key — NOT NULL
- arwPrice — int(11) — NOT NULL
- krwPrice — int(11) — NOT NULL
- groupType — int(11) — Foreign key → avatarpartsgrouptype.type — NOT NULL
- colorType — int(11) — Foreign key → avatarpartscolortype.type — NOT NULL
- sizeType — int(11) — Foreign key → avatarpartssizetype.type — NOT NULL
commercezonemannequin
- id — int(11) — Primary key — NOT NULL
- modelType — int(11) — NOT NULL
- partsType — int(11) — Foreign key → avatarpartstype.type — NOT NULL
- itemId — int(11) — NOT NULL
countrycode
- id — int(11) — Primary key — NOT NULL
- nameId — varchar(64) — NOT NULL
- code — int(11) — NOT NULL
departmenttype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
disciplinedetail
- type — int(11) — Primary key — NOT NULL
- name — varchar(32) — NOT NULL
disciplinereview
- restrictionType — int(11) — Primary key — NOT NULL
- restrictionDetail — int(11) — Primary key — NOT NULL
- disciplineDetail — int(11) — Foreign key → disciplinedetail.type — NOT NULL
disciplinetype
- type — int(11) — Primary key — NOT NULL
- name — varchar(32) — NOT NULL
emailcheck
- id — int(11) — Primary key — NOT NULL
- email — varchar(30) — NOT NULL
- authCode — int(11) — NOT NULL
emailconfirm
- id — int(11) — Primary key — NOT NULL
- email — varchar(30) — NOT NULL
emaillimit
- email — varchar(64) — Primary key — NOT NULL
- count — int(11) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
enabledtype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
faq
- id — int(11) — Primary key — NOT NULL
- question — text — NOT NULL
- answer — text — NOT NULL
forbiddenwords
- id — int(11) — Primary key — NOT NULL
- text — text — NOT NULL
frameimageappendtype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
friendrequest
- requestMemberId — varchar(100) — Primary key — NOT NULL
- receivedMemberId — varchar(100) — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
functiontable
- id — int(11) — Primary key — NOT NULL
- description — varchar(64) — NOT NULL
- value — int(11) — NOT NULL
gateway
- osType — int(11) — Primary key — NOT NULL
- appVersion — varchar(30) — Primary key — NOT NULL
- serverType — int(11) — NOT NULL
- stateType — int(11) — NOT NULL
- adminId — int(11)
- msgId — int(11) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
gradetype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
infinitecoderank
- memberId — varchar(100) — Primary key — NOT NULL
- userScore — float
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
inquiryanswertype
- type — int(11) — Primary key — NOT NULL
- name — varchar(64) — NOT NULL
inquirytemplate
- id — int(11) — Primary key — NOT NULL
- inquiryType — int(11) — Foreign key → inquirytype.type — NOT NULL
- name — varchar(64) — NOT NULL
- description — varchar(64) — NOT NULL
- content — varchar(512) — NOT NULL
- adminId — int(11) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
inquirytype
- type — int(11) — Primary key — NOT NULL
- name — varchar(64) — NOT NULL
interiorinstallinfo
- itemId — int(11) — Foreign key → item.id — NOT NULL
- prefab — varchar(64) — NOT NULL
- layerType — int(11) — NOT NULL
- xSize — int(11) — NOT NULL
- ySize — int(11) — NOT NULL
- removable — int(11) — NOT NULL
inventorycapacity
- itemType — int(11) — Foreign key → itemtype.type — NOT NULL
- capacity — int(11) — NOT NULL
item
- id — int(11) — Primary key — NOT NULL
- itemType — int(11) — Foreign key → itemtype.type — NOT NULL
- categoryType — int(11) — NOT NULL
- packageType — int(11) — NOT NULL
- name — varchar(64) — NOT NULL
- description — varchar(64) — NOT NULL
- prefab — varchar(64) — NOT NULL
- material — varchar(64) — NOT NULL
- thumbnail — varchar(64) — NOT NULL
- isNesting — int(11) — NOT NULL
- capacity — int(11) — NOT NULL
- purchaseType — int(11) — NOT NULL
- purchasePrice — int(11) — NOT NULL
- saleType — int(11) — NOT NULL
- salePrice — int(11) — NOT NULL
- gradeType — int(11) — Foreign key → gradetype.type — NOT NULL
itemtype
- type — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
itemuseeffect
- itemId — int(11) — Primary key — NOT NULL
- partsType — int(11) — NOT NULL
- chat — varchar(64) — NOT NULL
- animationName — varchar(64) — NOT NULL