VICMAG

Tables (16)

ACCOUNT (계정)

  • accountId (PK) — varchar(30) — Primary key — NOT NULL
  • password (Field) — varchar(300)
  • accountType (Field2) — varchar(10)
  • createdDateTime (Field3) — datetime
  • modifiedDateTime (Field4) — datetime

ADMIN (관리자계정)

  • accountId (PK) — varchar(30) — Foreign key → ACCOUNT.accountId — NOT NULL
  • name (Field) — varchar(60)
  • department (Field2) — varchar(60)
  • nickName (Field3) — varchar(30)

CATEGORY (카테고리)

  • category (PK) — nvarchar(20) — Primary key — NOT NULL

COMPANY (업체계정)

  • accountId (PK, FK) — varchar(30) — Foreign key → ACCOUNT.accountId — NOT NULL
  • companyRegistrationNumber (Field) — varchar(100)
  • name (Field2) — varchar(60)
  • phone (Field3) — varchar(30)
  • email (Field4) — varchar(150)

CONTENTS_TEXT (컨텐츠 텍스트)

  • contentsTextSeq (PK) — int — Primary key — NOT NULL
  • startTime (Field) — int
  • endTime (Field2) — int
  • text (Field3) — varchar(1000)
  • magazineContentsSeq (FK) — int — Foreign key → MAGAZINE_CONTENTS.magazineContentsSeq — NOT NULL

FAQ

  • faqSeq (PK) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • question (Field2) — varchar(1000)
  • answer (Field3) — varchar(1500)
  • accountId (Field4) — varchar(30)

KAKAO_USER (카카오유저)

  • id (PK, FK) — varchar(30) — Foreign key → USER.accountId — NOT NULL
  • kakaoIdNumber (Field) — int
  • connectedAt (Field2) — datetime

MAGAZINE (잡지)

  • magazineSeq (PK) — int — Primary key — NOT NULL
  • name (Field) — varchar(60)
  • coverImgUrl (Field2) — varchar(300)
  • price (Field3) — int
  • bgmUrl (Field6) — varchar(300)
  • tag (Field4) — varchar(1000)
  • createDateTime (Field5) — datetime
  • modifiedDateTime (Field7) — datetime
  • magazineBoardSeq (FK) — int — Foreign key → MAGAZINE_BOARD.magazineBoardSeq — NOT NULL

MAGAZINE_BOARD (잡지보드)

  • magazineBoardSeq (PK) — int — Primary key — NOT NULL
  • name (Field) — varchar(60)
  • boardImgUrl (Field2) — varchar(300)
  • description (Field3) — varchar(1500)
  • pricePerMonth (Field4) — int
  • cartegory (Field5) — varchar(40)
  • companyId (FK) — varchar(30) — Foreign key → COMPANY.accountId — NOT NULL

MAGAZINE_CONTENTS (잡지 컨텐츠)

  • magazineContentsSeq (PK) — int — Primary key — NOT NULL
  • page (Field) — int
  • contentsType (Field2) — varchar(10)
  • description (Field3) — varchar(300)
  • contentsType (Field4) — varchar(10)
  • contentsUrl (Field5) — varchar(300)
  • contentsThumbnailUrl (Field6) — varchar(300)
  • uploadStatus (Field7) — tinyint
  • magazineSeq (FK) — int — Foreign key → MAGAZINE.magazineSeq — NOT NULL

NOTICE (공지사항)

  • noticeSeq (PK) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • contents (Field2) — varchar(1500)
  • accountId (Field3) — varchar(30)

PAYMENT (결제)

  • purchaseSeq (PK) — int — Foreign key → PURCHASE.purchaseSeq — NOT NULL
  • totalPrice (Field) — int
  • description (Field2) — varchar(300)
  • paymentType (Field3) — varchar(20)
  • pg (Field4) — varchar(30)

PURCHASE (구매)

  • purchaseSeq (PK) — int — Primary key — NOT NULL
  • purchaseType (Field) — varchar(30)
  • userId (Field2) — varchar(30)
  • companyId (Field3) — varchar(30)
  • createdDateTime (Field4) — datetime

SINGLE_PURCHASE (단건 구매)

  • purchaseSeq (PK) — int — Foreign key → PURCHASE.purchaseSeq — NOT NULL
  • rating (Field) — double
  • magazineSeq (Field2) — int

SUBSCRIBE (구독구매)

  • purchaseSeq (PK, FK) — int — Foreign key → PURCHASE.purchaseSeq — NOT NULL
  • startDateTime (Field) — datetime
  • endDateTime (Field2) — datetime
  • rating (Field3) — double
  • magazineBoardSeq (Field4) — int

USER (사용자계정)

  • accountId (PK, FK) — varchar(30) — Foreign key → ACCOUNT.accountId — NOT NULL
  • name (Field) — varchar(20)
  • phone (Field2) — varchar(15)
  • email (Field3) — varchar(100)