GG-Pigs Application

Tables (9)

Copy Of Copy Of verification_mail (history_log)

  • verification_mail_id (history_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • name (title) — varchar(128) — History's title
  • Field (content) — varchar(512) — History's content
  • user_id — bigint — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
  • verification_mail_id (history_type_id) — bigint — Foreign key → Copy Of verification_mail.verification_mail_id — NOT NULL — AUTO_INCREMENT

Copy Of user (user_salt)

  • user_id (user_salt_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • is_authenticated (salt) — varchar(255) — NOT NULL — Salt for hash algorithm
  • Field (digest) — varchar(255) — NOT NULL — Digest of hash algorithm
  • user_id — bigint — Foreign key → user.user_id — NOT NULL — The user

Copy Of verification_mail (history_log_type)

  • verification_mail_id (history_type_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • name (type) — varchar(32) — NOT NULL — History's type

advertisement

  • advertisement_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • title — varchar(32) — NOT NULL — Title of ad
  • detail_description — varchar(128) — Detail description of ad
  • Field (keywords) — varchar(128) — The keywords of ad
  • image_path — varchar(128) — Path of stored image path
  • site_url — varchar(255) — Site url of ad
  • row_position — varchar(8) — Row position of ad
  • column_position — varchar(8) — Column position of ad
  • is_activated — char(1) — NOT NULL — Whether the status is active or not / (N: DEACTIVATED, Y: ACTIVATED)
  • user_id — bigint — Foreign key → user.user_id — The member who registers this advertisement
  • advertisement_type_id — bigint — Foreign key → advertisement_type.advertisement_type_id — NOT NULL — The type of advertisement

advertisement_request

  • advertisement_request_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • title — varchar(32) — NOT NULL — Title of ad
  • detail_description — varchar(128) — Detail description of ad
  • Field (keywords) — varchar(128) — Th keywords of ad
  • image_path — varchar(128) — Path of stored image path
  • site_url — varchar(255) — Site url of ad
  • row_position — varchar(8) — Row position of ad
  • column_position — varchar(8) — Column position of ad
  • review_status — varchar(32) — NOT NULL — Whether or not the review has been carried out / Enum type in java ('APPROVAL', 'NON_APPROVAL', 'PENDING')
  • reviewer — varchar(32) — The employee who reviewed the requested advertisement.
  • started_date — DATE — The date your post will be started
  • finished_date — DATE — The date your post will be finished
  • user_id — bigint — Foreign key → user.user_id — The member who requests to register advertisement
  • advertisement_type_id — bigint — Foreign key → advertisement_type.advertisement_type_id — NOT NULL — The type of requested advertisement

advertisement_type

  • advertisement_type_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • type — varchar(8) — NOT NULL — Advertisement's type / Enum type in java ('R1', 'R2', 'R3', 'R4', 'R5', 'R6')
  • width — varchar(8) — NOT NULL — Advertisement's width
  • height — varchar(8) — NOT NULL — Advertisement's height

common (COMMON)

  • created_date (CREATED_DATE) — DATETIME — When the data is created
  • updated_date (UPDATED_DATE) — DATETIME — When the data is updated

user

  • user_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • name — varchar(32) — User's name
  • email — varchar(64) — NOT NULL — UNIQUE / User's email
  • phone — varchar(16) — UNIQUE / User's phone
  • role — varchar(32) — NOT NULL — User's authorization / Enum type in java ('ROLE_MEMBER', 'ROLE_ADMIN')
  • oauth_type — varchar(32) — User's oauth type / Enum type in java ('KAKAO', 'NAVER', 'GOOGLE')
  • is_activated — char(1) — NOT NULL — Whether the status is active or not / (N: DEACTIVATED, Y: ACTIVATED)
  • is_authenticated — char(1) — NOT NULL — Whether this user is authenticated or not / (N: NOT AUTHENTICATED, Y: AUTHENTICATED)

verification_mail

  • verification_mail_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • name (to_email) — varchar(32) — NOT NULL — The receiver's email
  • email (from_email) — varchar(32) — NOT NULL — The sender's email
  • phone (verification_code) — varchar(16) — NOT NULL — The code for veification
  • Field (subject) — varchar(32) — Subject of mail
  • Field (content) — varchar(255) — Content of mail
  • role (status) — varchar(16) — NOT NULL — The result-status of verification mail
  • oauth_type (sent_date) — date — NOT NULL — Email sent date