베이알고 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)