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)