callbuslab

Tables (4)

bullentins (BULLETIN)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (CONTENTS) — TEXT
  • Key (LIKE_ID) — Foreign key → user.id — NOT NULL

comments (comment)

  • Key — Primary key — NOT NULL
  • Field
  • Key (MEMBER_ID) — BIGINT — Foreign key → user.id — NOT NULL
  • Key (ID) — BIGINT — Foreign key → bullentins.Key — NOT NULL

like (LIKE)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (BULLETIN_ID) — INT — Foreign key → bullentins.Key — NOT NULL
  • Key (USER_ID) — INT — Foreign key → user.id — NOT NULL

user (MEMBER)

  • id (ID) — BIGINT — Primary key — NOT NULL
  • Field (NICKNAME) — VARCHAR(20) — NOT NULL
  • Field2 (ACCOUNT_TYPE) — VARCHAR(20) — NOT NULL
  • Field3 (ACCOUNT_ID) — VARCHAR(20) — NOT NULL
  • Field4 (QUIT) — BOOLEAN — NOT NULL