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)