베이알고 1.0
테이블 (23)
billing_records
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- payment — INT(11) — NOT NULL
- method — ENUM('cash','creditCard','transfer','point') — NOT NULL
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- orderId — BIGINT(20) — 외래 키 → orders.id — NOT NULL
commentRecords
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- adminUserId — BIGINT(20) — NOT NULL
- columnName — VARCHAR(255) — NOT NULL
- prevValue — VARCHAR(255) — NOT NULL
- value — VARCHAR(255) — NOT NULL
- commentId — BIGINT(20) — 외래 키 → comments.id — NOT NULL
comments
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- comment — TEXT(65535) — NOT NULL
- isBlocked — TINYINT(1) — NOT NULL
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
coupons
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- name — VARCHAR(255) — NOT NULL
- detail — TEXT(65535) — NOT NULL
- issueType — ENUM('all','targeted') — NOT NULL
- point — INT(11) — NOT NULL
- validFromDate — TIMESTAMP
- validToDate — TIMESTAMP
- combineable — TINYINT(1) — NOT NULL
- issued — INT(11) — NOT NULL
- used — INT(11) — NOT NULL
- type — ENUM('issued','used') — NOT NULL
- serialNumber — VARCHAR(255)
f_a_q_s
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- type — ENUM('copyright') — NOT NULL
- question — TEXT(65535) — NOT NULL
- answer — TEXT(65535) — NOT NULL
fan_links
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- creatorId — BIGINT(20) — 외래 키 → users.id — NOT NULL
favorites
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
inquiries
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- type — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT(65535) — NOT NULL
- status — ENUM('uploaded','read','replied') — NOT NULL
- answer — TEXT(65535)
- answerDate — TIMESTAMP
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
leave_users
- id — BIGINT(20) — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- email_verified_at — TIMESTAMP
- password — VARCHAR(255) — NOT NULL
- remember_token — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- profileImage — VARCHAR(255)
- creatorName — VARCHAR(255)
- phone — VARCHAR(255)
- marketingEmailAgreement — TINYINT(1)
- marketingSMSAgreement — TINYINT(1)
- point — INT(11)
- downloadRemain — INT(11)
- uploads — INT(11)
- downloads — INT(11)
- totalBillingAmount — INT(11)
- fans — INT(11)
- lastLoginDate — TIMESTAMP
- bankName — VARCHAR(255)
- bankNumber — VARCHAR(255)
- loginId — VARCHAR(255) — NOT NULL
- leave_type — VARCHAR(255) — NOT NULL
- leave_note — VARCHAR(255)
- leaved_at — TIMESTAMP — NOT NULL
- confirm_code — VARCHAR(60)
- activated — TINYINT(1) — NOT NULL
- bankHolder — VARCHAR(60)
- likes — INT(11)
- comments — INT(11)
- profits — INT(11)
likes
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
notices
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- content — TEXT(65535) — NOT NULL
- registration_date — TIMESTAMP
orders
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- type — ENUM('cash','point') — NOT NULL
- price — INT(11) — NOT NULL
- billingMethod — ENUM('phone','creditCard','transfer','point') — NOT NULL
- status — ENUM('prepared','processing','completed') — NOT NULL
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
point_records
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- point — INT(11) — NOT NULL
- remainPoint — INT(11) — NOT NULL
- action — ENUM('save','use') — NOT NULL
- note — MEDIUMTEXT — NOT NULL
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- orderId — BIGINT(20) — 외래 키 → orders.id — NOT NULL
popups
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- imageFile — VARCHAR(255) — NOT NULL
- durationFromDate — TIMESTAMP
- durationToDate — TIMESTAMP
productInfoRecords
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- nameKor — VARCHAR(255) — NOT NULL
- nameEng — VARCHAR(255) — NOT NULL
- imageFile — VARCHAR(255) — NOT NULL
- tags — VARCHAR(255) — NOT NULL
- status — ENUM('uploaded','approved','blocked') — NOT NULL
- bankName — INT(11) — NOT NULL
- bankNumber — INT(11) — NOT NULL
- priceNormal — INT(11) — NOT NULL
- priceHigh — INT(11) — NOT NULL
- isShow — TINYINT(1) — NOT NULL
- creatorComment — TEXT(65535) — NOT NULL
- rejectNote — TEXT(65535) — NOT NULL
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
product_ranks
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- rank — INT(11) — NOT NULL
- shift — ENUM('up','down','stay') — NOT NULL
- steps — INT(11)
- stayDuration — INT(11)
- INDEX — `product_ranks_productid_foreign`
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
products
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- nameKor — VARCHAR(255) — NOT NULL
- nameEng — VARCHAR(255) — NOT NULL
- imageFile — VARCHAR(255) — NOT NULL
- tags — VARCHAR(255) — NOT NULL
- status — ENUM('uploaded','approved','blocked') — NOT NULL
- likes — INT(11)
- downloads — INT(11)
- comments — INT(11)
- totalProfit — INT(11)
- bankName — VARCHAR(255) — NOT NULL
- bankNumber — VARCHAR(255) — NOT NULL
- priceNormal — INT(11)
- priceHigh — INT(11)
- isShow — TINYINT(1)
- creatorComment — TEXT(65535)
- rejectNote — TEXT(65535)
- freeonly — TINYINT(1)
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
profits
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- amount — INT(11) — NOT NULL
- isApproved — TINYINT(1) — NOT NULL
- approveDate — TIMESTAMP
- rejectDate — TIMESTAMP
- rejectNote — TEXT(65535)
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- productId — BIGINT(20) — 외래 키 → products.id — NOT NULL
- orderId — BIGINT(20) — 외래 키 → orders.id — NOT NULL
reports
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- type — ENUM('toCreator','toUser') — NOT NULL
- password — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT(65535) — NOT NULL
- imageFile — VARCHAR(255)
- status — ENUM('uploaded','read','replied') — NOT NULL
- answer — TEXT(65535)
- answerDate — TIMESTAMP
- reporter — VARCHAR(255)
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
userInfoRecords
- id — BIGINT(20) — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- profileImage — VARCHAR(255)
- creatorName — VARCHAR(255)
- phone — VARCHAR(255)
- marketingEmailAgreement — TINYINT(1)
- marketingSMSAgreement — TINYINT(1)
- bankName — VARCHAR(255)
- bangNumber — VARCHAR(255)
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
user_coupons
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- noticeLogin — TINYINT(1) — NOT NULL
- noticeSMS — TINYINT(1) — NOT NULL
- noticeEmail — TINYINT(1) — NOT NULL
- used — TINYINT(1) — NOT NULL
- serialNumber — VARCHAR(255)
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
- orderId — BIGINT(20) — 외래 키 → orders.id — NOT NULL
- couponId — BIGINT(20) — 외래 키 → coupons.id — NOT NULL
user_ranks
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- rank — INT(11) — NOT NULL
- shift — ENUM('up','down') — NOT NULL
- steps — INT(11)
- stayDuration — INT(11)
- userId — BIGINT(20) — 외래 키 → users.id — NOT NULL
users
- id — BIGINT(20) — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- email_verified_at — TIMESTAMP
- password — VARCHAR(255) — NOT NULL
- remember_token — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- profileImage — VARCHAR(255)
- creatorName — VARCHAR(255)
- phone — VARCHAR(255)
- marketingEmailAgreement — TINYINT(1)
- marketingSMSAgreement — TINYINT(1)
- point — INT(11)
- downloadRemain — INT(11)
- uploads — INT(11)
- downloads — INT(11)
- totalBillingAmount — INT(11)
- fans — INT(11)
- lastLoginDate — TIMESTAMP
- bankName — VARCHAR(255)
- bankNumber — VARCHAR(255)
- loginId — VARCHAR(255) — NOT NULL
- confirm_code — VARCHAR(60)
- activated — TINYINT(1) — NOT NULL
- bankHolder — VARCHAR(60)
- likes — INT(11)
- comments — INT(11)
- profits — INT(11)