test
Tables (14)
Artist
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL — 작가 이름
- password — VARCHAR(255) — NOT NULL — 비밀번호
Character
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.id — NOT NULL
- characterCreationId — INT — Foreign key → CharacterCreation.id — NOT NULL — 캐릭터 제작 정보 id
- name — VARCHAR(255) — NOT NULL — 이름
- species — VARCHAR(255) — NOT NULL — 종
- detailSpecies — VARCHAR(255) — NOT NULL — 세부종
- gender — ENUM('0', '1') — NOT NULL — 성별
- birthday — DATE — NOT NULL — 생일
- rainbow — ENUM('0', '1') — NOT NULL — 무지개다리 여부
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)
- INDEX — `FK_6bf99ef41126e524bd749f2712f`
CharacterApplication
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.id — NOT NULL
- characterApplicationStatusId — INT — Foreign key → CharacterApplicationStatus.id — NOT NULL — 캐릭터 신청 상태
- photos — TEXT — NOT NULL
- requests — VARCHAR(255) — NOT NULL — 요청사항
- name — VARCHAR(255) — NOT NULL — 이름
- species — VARCHAR(255) — NOT NULL — 종
- detailSpecies — VARCHAR(255) — NOT NULL — 세부종
- gender — VARCHAR(255) — NOT NULL — 성별
- birthday — DATE — NOT NULL — 생일
- rainbow — VARCHAR(255) — NOT NULL — 무지개다리 여부
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)
- INDEX — `FK_af22a8eceb0343c0e0e9d6e274f`
- INDEX — `FK_16ac5faf489d7b6eec3e4e242b0`
CharacterApplicationStatus
- id — INT — Primary key — NOT NULL
- status — VARCHAR(255) — NOT NULL — 캐릭터 신청 상태
CharacterApplicationToCharacteristic
- id — INT — Primary key — NOT NULL
- characterApplicationId — INT — Foreign key → CharacterApplication.id — NOT NULL — 캐릭터 신청 정보 id
- characteristicId — INT — Foreign key → Characteristic.id — NOT NULL — 반려동물 성격, 특징 id
- INDEX — `FK_93c635ac5d85bc491189e974d35`
- INDEX — `FK_32e7348bc13f1cb204c9a62c9a2`
CharacterCreation
- id — INT — Primary key — NOT NULL
- characterApplicationId — INT — Foreign key → CharacterApplication.id — NOT NULL
- artistId — INT — Foreign key → Artist.id
- characterCreationStatusId — INT — Foreign key → CharacterCreationStatus.id — NOT NULL — 캐릭터 제작 상태 ID
- characterImage — VARCHAR(255) — 캐릭터 이미지
- isSelected — TINYINT — NOT NULL — 선택 여부
- label — VARCHAR(255) — NOT NULL — 라벨A,B,C
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)
- INDEX — `FK_1f926bb8e92f934389805ebc7bb`
- INDEX — `FK_4ca4b1408c144f7ca6bddcd17c1`
- INDEX — `FK_6c234c021a5fdb2e7124460b77a`
CharacterCreationStatus
- id — INT — Primary key — NOT NULL
- status — VARCHAR(255) — NOT NULL — 캐릭터 제작 상태
CharacterPhotoReRequest
- id — INT — Primary key — NOT NULL
- characterApplicationId — INT — Foreign key → CharacterApplication.id — NOT NULL
- reasron — VARCHAR(255) — NOT NULL — 재요청사유
- photos — TEXT — 사진
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)
- INDEX — `FK_71adb998060535fd6b69608efb7`
CharacterToCharacteristic
- id — INT — Primary key — NOT NULL
- characterId — INT — Foreign key → Character.id — NOT NULL — 캐릭터 id
- characteristicId — INT — Foreign key → Characteristic.id — NOT NULL — 반려동물 성격, 특징 id
- INDEX — `FK_50a9a74f088e77e90c0e286e0ad`
- INDEX — `FK_281ed8bf4828d830f7fc0d30267`
Characteristic
- id — INT — Primary key — NOT NULL
- type — VARCHAR(255) — NOT NULL — 성격,특징
DelayedCharacterApplicationHistory
- id — INT — Primary key — NOT NULL
- characterApplicationId — INT — Foreign key → CharacterApplication.id — NOT NULL
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)
- INDEX — `FK_3ce52815d84cc22f6da42c61287`
Notice
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.id — NOT NULL
- noticeTypeId — INT — Foreign key → NoticeType.id — NOT NULL
- message — VARCHAR(255) — NOT NULL — 알림 내용
- isRead — TINYINT — NOT NULL — 읽음 여부
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)
- INDEX — `FK_92993916c3e207cc7acca44950b`
- INDEX — `FK_b7dadf864672acaffc4b24c46d7`
NoticeType
- id — INT — Primary key — NOT NULL
- type — VARCHAR(255) — NOT NULL — 알림 종류
User
- id — INT — Primary key — NOT NULL
- nickname — VARCHAR(255) — NOT NULL — 닉네임
- phoneNumber — VARCHAR(255) — NOT NULL — 휴대폰 번호
- createDate — DATETIME(6) — NOT NULL
- updateDate — DATETIME(6) — NOT NULL
- deleteDate — DATETIME(6)